Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 7 of 7 total |
Temporary files |
Mon, Jul 12 2010 9:03 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Can temporary files used in table maintenance (eg optimisation) be given a name that will allow the table to be identified please. I just had a "senior" moment and clicked the icon to close the PC down whilst it was busy optimising. I am assuming that the new table is built then the original deleted and the new ones renamed but it would be nice to be able to check.
Roy Lambert |
Mon, Jul 12 2010 3:30 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< Can temporary files used in table maintenance (eg optimisation) be given a name that will allow the table to be identified please. I just had a "senior" moment and clicked the icon to close the PC down whilst it was busy optimising. I am assuming that the new table is built then the original deleted and the new ones renamed but it would be nice to be able to check. >> If the optimization process didn't succeed, then the original files should be intact. If they aren't, then the .old file backups should have a new date/time stamp and will be the original files. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jul 13 2010 3:37 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< Can temporary files used in table maintenance (eg optimisation) be given >a name that will allow the table to be identified please. I just had a >"senior" moment and clicked the icon to close the PC down whilst it was busy >optimising. I am assuming that the new table is built then the original >deleted and the new ones renamed but it would be nice to be able to check. > >> > >If the optimization process didn't succeed, then the original files should >be intact. If they aren't, then the .old file backups should have a new >date/time stamp and will be the original files. That's what I assumed, but the temporary tables created give no indication of which table was involved ie just the normal temporary table naming system eg WORKDELL88847401163268NLH1 rather than CompaniesBeingOptimisedTemporaryTable or something Roy Lambert |
Tue, Jul 13 2010 6:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< That's what I assumed, but the temporary tables created give no indication of which table was involved ie just the normal temporary table naming system eg WORKDELL88847401163268NLH1 rather than CompaniesBeingOptimisedTemporaryTable or something >> That's just it - you don't want those files. If the temporary file was not copied back to the original (creating an .old beforehand), then it can just be deleted because it's junk. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jul 14 2010 3:12 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
><< That's what I assumed, but the temporary tables created give no >indication of which table was involved ie just the normal temporary table >naming system eg WORKDELL88847401163268NLH1 rather than >CompaniesBeingOptimisedTemporaryTable or something >> > >That's just it - you don't want those files. If the temporary file was not >copied back to the original (creating an .old beforehand), then it can just >be deleted because it's junk. I know that, but I'd still like to know which table was being worked on. One benefit would be that I could then restart the process at the appropriate point rather than having to run through it all again. This could save me an hour or more. Roy Lambert |
Thu, Jul 15 2010 6:46 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Roy,
<< I know that, but I'd still like to know which table was being worked on. One benefit would be that I could then restart the process at the appropriate point rather than having to run through it all again. This could save me an hour or more. >> Okay, I'll have to look into this further to make sure that I'm not setting EDB up for a conflict by doing this. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Jul 16 2010 4:06 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Okay, I'll have to look into this further to make sure that I'm not setting >EDB up for a conflict by doing this. Thanks. I had thought of a log file, but since the "problem" was caused by me turning the PC off when it was running I wasn't sure it would work, but I've just realised I can close it off between each table then its just down to the OS getting it to disk. So if altering the names would be a hassle don't bother. Roy Lambert |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |