Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
how to auto-delete temporary tables |
Sat, Jul 15 2006 2:33 PM | Permanent Link |
Annar | Hi! Is there a way to automatically delete the temporary tables (numerical tables in db dir) created by queries? If not, what is the easiest way to delete those which are not used. |
Sat, Jul 15 2006 3:29 PM | Permanent Link |
"Ralf Mimoun" | Annar wrote:
> Hi! > > > Is there a way to automatically delete the temporary tables > (numerical tables in db dir) created by queries? They will be deleted when the query objects that use these tables are closed. > If not, what is the easiest way to delete those which are not used. Close the queries. If some files are left, then something ugly happens, like a crash. Then simply delete the files. Ralf |
Mon, Jul 17 2006 8:54 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Annar,
<< Is there a way to automatically delete the temporary tables (numerical tables in db dir) created by queries? >> The first thing you should do is make sure that your TDBISAMSession.PrivateDir property is set to a temporary directory on the local drive: http://www.elevatesoft.com/dbisam4d5_tdbisamsession_privatedir.htm That will keep those tables out of your database directory, and then you can simply delete all of the files in the temporary directory as necessary. Also, keep in mind that these files are only left around when your application improperly terminates. Under normal circumstances, DBISAM will delete them automatically when it no longer needs them. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |