|
Home > Archive > Programming with dBASE > February 2006 > Sportman7@netwero.net
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sportman7@netwero.net
|
|
|
| Am having a real slowdown in opening an app. If I wish 3 queries on the same table in a single datamodule will I expect 3 times the load times across a network, or once a table is queried once is there a significant reduction in loading it into another q
uery?
Thanks for any ideas on this,
Rick
| |
| *Lysander* 2006-02-07, 3:23 am |
| In article <y1oPcH1KGHA.1104@news-server>, Sportman7@netzero.net says...
> Am having a real slowdown in opening an app. If I wish 3 queries on the =
same table in a single datamodule will I expect 3 times the load times acro=
ss a network, or once a table is queried once is there a significant reduct=
ion in loading it into another query?
>=20
> Thanks for any ideas on this,
Depending on your settings for sharing memory (BDE-Settings!), according=20
to the documentation your queries should share the resources.
Drawback: in modern systems it is urgently recommended to avoid all=20
types of client caching with file-databases. I would not be surprised if=20
this, again, would sequential and full loading of the 3 queries in your=20
case.
--=20
ciao,
Andr=E9
| |
|
| Andre,
Thanks. I might need to look at what affect cacheing has on the 3 queries.
Rick
*Lysander* Wrote:
> In article <y1oPcH1KGHA.1104@news-server>, Sportman7@netzero.net says...
er query?[color=darkred]
>
> Depending on your settings for sharing memory (BDE-Settings!), according
> to the documentation your queries should share the resources.
>
> Drawback: in modern systems it is urgently recommended to avoid all
> types of client caching with file-databases. I would not be surprised if
> this, again, would sequential and full loading of the 3 queries in your
> case.
>
> --
> ciao,
> André
|
|
|
|
|