Hi, I'm from Argentina so excuse my english, I'll try not to talk Tarzan-Like english. Well, I use SQLdirect components under delphi 7.0 to connect with SQL Server 2000 databases and the preformance sucks (comparing it with Interbase/Firebird/Oracle). I dont know if I need to set up something in the SQL Server or in the SQLdirect components. Google searches did'nt work and the SQLDirect homepage has no information.
I hope someone can help me or guide me to the right direction.
Try running your statements in Query Analyzer. If the performance still sucks, then the problem is in your code and we may be able to help. Otherwise, the problem is in SQLDirect and you will have to get help with that component.
If it's not practically useful, then it's practically useless.