Ingres QT (development projects tool)

[siddus]

Hi, I wish to evaluate the Ingres QT (query tool) which is available for download on the Ingres projects website. I am using Ingres 2006 on a Sun OS based server which I connect to using the client on my windows based machine. The windows installation of Ingres is 2.6.

When I try to connect to one of the databases on the 2006 node from QT, the app just hangs for a long time. Any clue what could be wrong? I am using qt26_v10a. Any help would be appreciated.

Cheers.

[siddus]

Just an update....
After waiting for a long time, the app did connect however it takes a lot of time to SQL anything on the dbase. I am clueless why it is taking so long!!

[bilgihan]

This might be caused due some network issues.
Did you try using ip address instead of hostname in vnode definition?
ON command prompt, what is the behaviour of
- ping <ip>
- ping hostname

Bilgihan

[mahjo03]

I am not sure if this is a network related issue or perhaps due to the number of tables & views in this database or something else. Query Tool performs a similar set of queries to the terminal monitor "help" command when it populates the list of tables and views for a database. Could you try doing this in terminal monitor to compare the response time to help isolate the problem?

> sql vnode::database
* help\g

How does the response time compare to querytool? How many tables/views are we dealing with here?

John

[siddus]

@Bilgihan - its certainly not a network problem. I tried running diagnostics and the network is up and running well. No issues there.

@John - Tried that on terminal monitor and the response was pretty quick. Around 9000+ objects retrieved. Also I am able to use VDBA without facing any such problems. There is no delay and things are quite seamless as far as using any feature of VDBA is concerned.

I was hoping that the tool would provide some more features than VDBA which is why I wanted to evaluate it.

[Bodo]

I have just downloaded "qt" and can't see any performance problems with it (neither when connecting nor when drilling down the database or executing queries).
Did you use an existing vnode or did you create an ad-hoc connection?

[mahjo03]

I will run some diagnotics with an installation of that size (around 10K objects) to see if I can reproduce the issue and islolate the problem. Stay tuned...

[siddus]

When I start QT it seems to picking up the node information from VDBA. I did not create any new nodes. As a matter of fact when I deleted a node from QT the same node disappeared from VDBA too. I am assuming it gets this information automatically from the ingres installation.

[denjo02]

That is indeed the case. If you open up a Command Window and enter the command "netutil" you will also see the vnodes defined to the installation.

[mahjo03]

It appears as if the lag time is not with the query itself but with process being used to create the child nodes in the tree for the database. I will need to look for a more efficient method to populate the treeview field.