Local SQL and Indices - Help!

Greg Pencheff

Delphi Developer

Tue, 18 Sep 2001 03:00:00 GMT

Local SQL and Indices - Help!

I have multi user 16 bit Delphi database running on a Novell network using
local SQL. The workstations accessing the database range from PII 200Mhz to
lowly 486sx-25 machines. The database only has 16,000+ records but the
queries run very very slow on the slower machines.

How do I use indexes to speed things up? I can find no references to using
indexes with local SQL in any of the help files, but I keep seeing comments
in this newsgroup that using indexes with local SQL will increase
performance i.e. "then pass the primary key as paramneter to the query ".

How? Any help would be very much appreciated.

Greg Pencheff
pench...@lancnews.infi.net

Other Threads

1. Help: Creating Indexes in Local SQL

2. Local SQL, works in MS SQL, not in local SQL

3. Local SQL challenge - for all you local SQL gurus:

4. SQL Queries and Local Tables with Indexes - Speed????

5. Creating dbase expression Indices with Local SQL

6. Sql Local pb with secondary index

7. Secondary indexes for LOCAL SQL queries...?

8. How to use indexes with local sql (D2)

9. Local SQL and indexes

10. Using an index with local SQL