Copying Query Data Into a Table (without using insert - into)

Dave Bissett

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Copying Query Data Into a Table (without using insert - into)

I am looking for a way to copy a queries result set into a table, given the
query.
The final result is going to be a tree structure of a set of database
records. I use the TDataset now, and apply filters, but that's just
hideously slow (3 minutes for 2800 records). What I have in mind is to
index the tables that describe the structure, then use setrange, which is
wildly fast. However, I can't do this from a query, hence my requirement to
shove it into a table. Any thoughts? Alternatives?

Thanx for any help in advance.
Dave Bissett

Other Threads

1. Inserting Data into Two Different Tables by querying from a single Table

2. Inserting Data into Two Different Tables by querying from a single Table

3. Help with fast inserts into a SQL Table without using the DB-Library API

4. using a query to copy data from one db to another

5. Parameterised Query when used to Insert Data

6. How to do an Update query or a Delete Query or an Insert Query using D3

7. fast inserts on MSSQL without using Bulk Insert and textfiles

8. Update query using data from another table

9. Problems Using Query Component to Change Data in Master/Detail Tables

10. New Table pointer and/or copying a tables data