Unanswered: Performance problem with Informix ODBC Driver 2.8
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
Anybody can help me please, what is the problem origen ?
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.
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.