Mega Code Archive

 

Categories / Delphi / ADO Database

 

Improving performance

Question: Is there any special trick to improve performance? Answer: Most importantly - add persistent field objects for your tables. Create expressions with as few functions as possible. Instead of doing Sum(Field1)+Sum(Field2) you should do Sum(Field1+Field2). The last one is a lot faster.