|
|
#1
03-30-2004, 02:23 AM
|
|||
|
|||
from Access DB through ADO to TStringGrid(too slow)
from Access DB through ADO to TStringGrid(too slow)... How can I make better speed of my app? searching record... adding to stringgrid and so on... Maybe I should use other custom grid component...
oasis@eurosoft.lv http://oasis.yo.lv beginner! 
|
|
#2
03-30-2004, 05:19 AM
|
|||
|
|||
|
RE: from Access DB through ADO to TStringGrid(too slow)
In your Access DB are you using "linked tables" (unfortunatelly I don't know how to write in english, but maybe you understand)?
Other question... your Access DB file is through a network, or is a local file? Both conditions slow your application speed. <cr> if it helped please accept</cr> Paullus Martins de Sousa Nava Castro Brazil (Brasil) Brasília - DF
|
|
#6
03-30-2004, 05:46 AM
|
|||
|
|||
|
RE: from Access DB through ADO to TStringGrid(too slow)
In my opinion is fine, though I'm not an DBA.
hehehe... In time: indexed is different from what I wanted to ask you. If you want speed you MUST index your search fields, the price is the size of the database getting bigger :-) I asked you if your DB is linked to another Access DB file searching on tables from it. (Maybe you understand now). Other point: try using ADOQuery. In that you can especify your search conditions (SQL statement) making your program faster. <cr> if it helped please accept</cr> Paullus Martins de Sousa Nava Castro Brazil (Brasil) Brasília - DF
|
|
#8
03-30-2004, 06:46 AM
|
|||
|
|||
|
RE: from Access DB through ADO to TStringGrid(too slow)
No... i don't NEED o use ADOQuery, it's recommended. Actually I never worked with TADODataSet. After talked to you I looked at it. It seems to have the same funcionality of ADOQuery. So it's fine.
As I said... I think the time response is allright. <cr> if it helped please accept</cr> Paullus Martins de Sousa Nava Castro Brazil (Brasil) Brasília - DF
|
 |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
