Markku Nevalainen
Guest
|
 Posted: Sat Sep 11, 2004 12:22 pm Post subject: Re: improve table.open speed (paradox) |
 |
|
Santy Concepción wrote:
| Quote: |
If table is too big, this code takes some seconds to run.
I have tried to Filter and then Open it:
Table1.Filter := filter;
Table1.Filtered := True;
Table1.Open;
|
You did not tell what kind of DB operation you are actually trying to
perform.
Record count of 38.000 is peanuts, if you have any indexed field there,
and you can seek the data by using that index. Paradox always requires
the Primary Index, and then you can add Secondary indexes as much as
you need.
With indexed searches, that is using FindKey for instance, you should
always get a couple of seconds response time with local databases.
| Quote: | I have tried to SetRange, but SetRange needs the table to be opened.
|
If you use SetRange with indexed field, you should get the table
open with that selected dataset in some seconds. Filter is not as effective,
if you do not know what you are doing.
If there are a bunch of Master/Detail connections with this table that you
are opening, they can also cause some slowness when they get open.
Markku Nevalainen
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
