MS SQL7 with cached updates

Gregory R. Runnels

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

MS SQL7 with cached updates

I've got an app that the client wants to run from a network drive. It
uses SQL7 with cached updates. The default caching is to the networked
drive. It seems kind of slow. Should I set the cache to the local
drive? and if so, how would I do that? Thanks.

Jacob Peders

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:MS SQL7 with cached updates

g...@rdtech.com (Gregory R. Runnels) wrote in
<3958B7E6.55B65...@rdtech.com>:

Quote

>I've got an app that the client wants to run from a network drive. It
>uses SQL7 with cached updates. The default caching is to the networked
>drive. It seems kind of slow. Should I set the cache to the local
>drive? and if so, how would I do that? Thanks.

Not a good idea to cache on a network drive as the cache files might
conflict, plus the network is always a bottleneck...

Try:

<tdatabase>.Session.PrivateDir := <localdir>;

--
Jacob Pedersen
AK Techotel
J.Peder...@techotel.dk

Other Threads

1. Cached Updates are dead - long live cached updates?

2. Problem updating on MS SQL7

3. MS Access + cached updates problem

4. Cached Updates with MS SQL Server

5. Cached Updates & MS Access

6. MS-Access and Cached Updates??

7. Cached updates with MS Access

8. Cached Updates QUESTION: Sorting table of updated and non-updated records

9. Problem accessing MS Access odbc database after installing MS SQL7

10. Cached Updates / Cache Full Error?