Jump to content
Sign in to follow this  
al17nichols

FDMemtable with localsql

Recommended Posts

Is there a way to determine if localsql is using an index when running a query against an FDMemtable?

Share this post


Link to post

Take a look at this line in the link Lars posted:

  • CREATE INDEX / DROP INDEX. Instead of the SQL indexes, use the dataset indexes.

Seems to me that means if the TFDMemTable has indexes they will be used.

Share this post


Link to post
Quote

The Local SQL engine supports SQLite SQL dialect with some limitations. The following SQL commands are not supported for the TDataSet data sources:

  • ALTER TABLE ... ADD COLUMN. Instead, change the dataset structure.
  • DROP TABLE. When a dataset is unlinked from the Local SQL engine, it is automatically dropped (not freed).
  • CREATE INDEX / DROP INDEX. Instead of the SQL indexes, use the dataset indexes.
  • CREATE TRIGGER / DROP TRIGGER. Instead of the triggers, use the dataset events.

If you can programmatically add an index - i.e. without using SQL - it should work - but I've never tried it.

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×