Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 5 of 5 total

Sat, Dec 5 2009 9:25 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Hopefully a silly question. When you create a table in memory (say via a CREATE TABLE AS sql) and then add / alter indices does a .old file get created? Roy Lambert
Sun, Dec 6 2009 7:30 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << Hopefully a silly question. When you create a table in memory (say via a CREATE TABLE AS sql) and then add / alter indices does a .old file get created? >> Yes. EDB uses them to restore the table files if the CREATE/ALTER index fails. -- Tim Young Elevate Software www.elevatesoft.com
Sun, Dec 6 2009 9:08 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim ><< Hopefully a silly question. When you create a table in memory (say via a >CREATE TABLE AS sql) and then add / alter indices does a .old file get >created? >> > >Yes. EDB uses them to restore the table files if the CREATE/ALTER index >fails. Ouch. In that case is there a way of getting rid of them if they hang around until the app closes. I use a lot of memory tables with added indices and this might contribute to the slow down I'm seeing towards the end of the day. Roy Lambert
Sun, Dec 6 2009 3:23 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << Ouch. In that case is there a way of getting rid of them if they hang around until the app closes. I use a lot of memory tables with added indices and this might contribute to the slow down I'm seeing towards the end of the day. >> I'll double-check, but if they aren't being removed automatically already, I'll make sure that they are for the next build. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Dec 7 2009 2:45 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim ><< Ouch. In that case is there a way of getting rid of them if they hang >around until the app closes. I use a lot of memory tables with added indices >and this might contribute to the slow down I'm seeing towards the end of the >day. >> > >I'll double-check, but if they aren't being removed automatically already, >I'll make sure that they are for the next build. I don't know if that's the reason, or its a Vista thing on my PC or it was a Vista thing on the fileserver PC (which is why its now an XP PC just to see) or the network getting tired because its been working hard all day or what. I know how I as a programmer can get rid of .Olds on disk Is there a way I can do it in memory? Roy Lambert