ZifNab
asked on
Tables,queries : Memmory? Speed?
Hi all,
Have to make access to a lot of tables. On a lot of tables I have to select the same ranges. ...
What should I do?
Join the tables to one query?
Isn't this slowing down the program?
Or is the combined tables query as fast as the different tables ranged? What about the memmory?
How much memmory do you need when you connect a TTable to a database table. And what if you add two TTables to one database table. What about the speed?
What if you don't select all fields in the fieldeditor? Does this reduce the needed memmory and icreases speed. Or does this do nothing?
Help! Need some advice.
Zif.
Have to make access to a lot of tables. On a lot of tables I have to select the same ranges. ...
What should I do?
Join the tables to one query?
Isn't this slowing down the program?
Or is the combined tables query as fast as the different tables ranged? What about the memmory?
How much memmory do you need when you connect a TTable to a database table. And what if you add two TTables to one database table. What about the speed?
What if you don't select all fields in the fieldeditor? Does this reduce the needed memmory and icreases speed. Or does this do nothing?
Help! Need some advice.
Zif.
Which database ?
ASKER
Access95 v7.0
Each table or query has one logical connection to an Access database. Thus many tables will have many connections, but a query will only have one logical connection from Delphi to Access, even if the query joins many Access tables. (I.e. a query only has one handle from Delphi.) This should make the query quicker than using many tables (if the query doesn't use an "Order By") and should use less memory too.
Exactly how much memory is used for a table or query I cannot say...
JB
Exactly how much memory is used for a table or query I cannot say...
JB
ASKER
Hi JimBob,
That's the answer I wanted to hear, thanks!
What about the total fields? (TFieldEditor)
You can post your comment as an answer.
Regards,
Zif.
That's the answer I wanted to hear, thanks!
What about the total fields? (TFieldEditor)
You can post your comment as an answer.
Regards,
Zif.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks.
ASKER