how to create an index for a query

Kemal

Delphi Developer

Tue, 13 Jan 2004 14:06:39 GMT

how to create an index for a query

how can I list the data after executing an sql statement 20 by 20 if I have
lot's of data. I mean I want to show next 20 group of data after pressing
the next button on browser

Aage Johanse

Delphi Developer

Wed, 14 Jan 2004 05:43:30 GMT

Re:how to create an index for a query

First off: Browsing applications are _not_ a good thing with C/S
databases.
If you really need it, probably a Stored Procedure (with some
parameters) is probably the best solution today. Performance may be
BAD. LIMIT/TOP functionality may appear in Interbase or Firebord
later. More convenience, but performance may still be less than
stellar.

Regards,
Aage J.

Quote

Kemal wrote:
> how can I list the data after executing an sql statement 20 by 20 if I have
> lot's of data. I mean I want to show next 20 group of data after pressing
> the next button on browser

Other Threads

1. Index - Creating new MDX index without previous index to copy

2. Indexes : creating indexes after using Batchmove(batcopy)

3. Create index of Paradox table -- Table is not indexed

4. Create index of Paradox table -- always index is out of date

5. Create a query from an existing query (Paradox-DB)

6. Local SQL - Create Index - Create Non-Maintained?

7. Why are sql queries created by Visual Query builder slower than same created by database desktop queries.

8. Delphi2/BDE32 query not using index

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

10. BDE: SQL Queries and dBase Indexes (Performance?)