Discussion Locked

Using SQL in PC-Based database?

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Dear All,

In PC-Based database(say paradox) application, I find that using SQL is quite convenient but a little slower than doing the same using TTable control, especially on seeking record(s). Does database's Index work for SQL query in this caes? How can make faster and convenient using SQL query in PC-Based databse application?

Thanks in advance for your kind attention.

Ben
from China

1 reply

by bojidar alexandrov

I am Delphi programmer and have developed apps with direct access(TTable) and SQL.
That is true - with SQL is litle slower but it is the right choice. If table has index SQL will use it if is possible. If you make good querys and with suitable indexes it will perform good.

SQL will be ever faster for complex querys.

With SQL you also have scalability - try to use standart SQL without Paradox-specific things and you can transfer easy this application to server based DB when it needs.

This discussion is closed to new replies.