Link to home
Start Free TrialLog in
Avatar of vpotnis
vpotnis

asked on

Speed issues with BDE+Informix

I have application which has been developed on Delphi 2.x with Informix Standard engine 7.x database. I am using BDE to connect the client to the server (Database). Most of the queries take a long time to fetch the data. But the same queries if fired from the server goes thru in a split of a second. I have checked &Ā tested the network, informix, OS settings. All seem to be correct. Is there any way to speed up this. ???
Avatar of GOMF
GOMF
Flag of Denmark image

hmm, this is just a thought!

Way back before the dinos I was programing MS Access 2.0 and using an SQL server..I had the exact same problem, until I realised that the I was not using "Pass through" SQL - this means that the program that handles the client end must translate or atleast preempt it before passing it to the SQL server..could this be your problem ?


Regards,

GOMF
ASKER CERTIFIED SOLUTION
Avatar of Portal
Portal

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial