Hi, I`m Alejandro ayala, I'm new in this group y now I have a problem in my application ( c++ builder 5.0 ) when the user logged is informix querys are so fast but when another users are logged performance query is so low, I give all grants and connect permission
for users.

Anybody can help me please, what is the problem origen ?

thank's a lot

What database server do you use? Version?
What is your setnet32 config.
How about the ilogin demo, is it slow with other users?

Hi Roelwe, thank's for your answer.

My DD version is IDS2000 9.21 TC5 for Windows 2000
Setnet Configuration is:

Informix Sever: ol_digpres
Host name: 10.23.3.15
Protocol name: onsoctcp
Service Name: 1526
Options: None

The ilogin demo with any user is normal ( so fast ) the same that with informix user.

When run my application ( c++ builder ) and use the SQL monitor tool I see that when the user logged was informix a run a query total sql instructions executed using the ODBC driver client ( version 2.8 ) are few in comparation when other users are logged ( a lot of sql instructions are execute, like a sequential searching ).

When run the same query in dbacces is fast, only using ODBC is slow.

Thank's for your help

Hi,

Do you use ODBC from another machine?
Did you check ilogin demo from another machine?
I don't really see why the user informix runs faster qry's than another user... Normally user authentication is done by the os.
Once the dbserver knows who, he just executes it.
On ething you can do is try to trace your calls from server to client and vs versa.

set the environment variable SQLIDEBUG=2:<path_to_debugfile>
use the sqliprint to format the output.
compare the two sqlidebu outputs and check where the problem lays.