Determining where the BDE writes Temp Tables?

[cmgaviao]

Hello All,

I have an application that has to cursor through fairly large amounts of data moving up and down to determine the state of specific record groupings.

I've decided to use a Ramdrive to speed running up and down throught the queries...Which actually speeds things up quite a bit..

There are also quite a few QBE's (I didn't put these in, but I have to live with what's already there for now).

My question is, in order to fully take advantage of the RamDrive, Is there anyway to determine or tell the BDE where specifically it is to create any TempTables that it might create for processing Queries/QBE's? Also, if there's any BDE gurus out there, are there any specific BDE settings which will speed the processing of local paradox tables? If the information's of any use, my tables are quite large being that they are denormalized for insertion into an SQL server database used for reporting purposes.

 

[LucieLastic]

hi

Use the TDatabase.directory property. Here's a snippet of the help:

"
Use Directory at runtime to change or retrieve the working directory for a Paradox or dBASE database. This is the location these databases use to create temporary tables at runtime.
:
"

lou

 

[cmgaviao]

Weez,

Thanks a million for that...Soon as I get back to my RamDisk machine in the states I'll put it to use!