Hi,
I have a response time problem in a Delphi application. There is a table with many small records that I have to process locally sequentially until I get a record that satisfies a condition -can`t do with a stored procedure-
Would like to read a record -along with many others in the page- so I minimize network transfers.
Have tried increasing cache but don`t see a difference.
Could you recommend a tool that could help me to monitor the effect of changing configuration parameters?
I´m currently using Interbase drivers. Could I get better options with dbExpress?

Hope you guys can help me-