![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 8 of 8 total |
![]() |
Wed, Oct 7 2009 4:26 AM | Permanent Link |
Edward Jones | I have just run a SQL DELETE statement on a table to wipe it but I see the size of the .EDBTbl file is still 302Mb even though there is "nothing" in it?
Is there anyway to really remove this data, the reason being that I am trying to create a blank data set to fit on a CD without zipping it, and at the moment the whole database is over 800Mb even though each of the tables is "empty"? Regards Edward Jones |
Wed, Oct 7 2009 4:40 AM | Permanent Link |
Uli Becker | Edward ,
> Is there anyway to really remove this data, the reason being that I am trying to create a blank data set to fit on a CD without zipping it, and at the > moment the whole database is over 800Mb even though each of the tables is "empty"? Just optimize the table. Uli |
Wed, Oct 7 2009 6:00 AM | Permanent Link |
Edward Jones | Hi, thanks for the fast reply! I have now found the OPTIMIZE TABLE SQL command and have run it and that does the trick! Thanks again!
Edward Jones Uli Becker wrote: Edward , > Is there anyway to really remove this data, the reason being that I am trying to create a blank data set to fit on a CD without zipping it, and at the > moment the whole database is over 800Mb even though each of the tables is "empty"? Just optimize the table. Uli |
Wed, Oct 7 2009 1:16 PM | Permanent Link |
Roy Lambert NLH Associates ![]() | Uli
or use a DVD ![]() Roy Lambert |
Wed, Oct 7 2009 1:25 PM | Permanent Link |
Uli Becker | Roy
> or use a DVD ![]() or a BluRay (just to be safe). ![]() Uli |
Thu, Oct 8 2009 3:40 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Uli
>or a BluRay (just to be safe). ![]() I'd actually regard that as unsafe <vbg> Think about it. Most modern PC's have a DVD reader but .... Roy Lambert |
Thu, Oct 8 2009 8:06 AM | Permanent Link |
Uli Becker | Roy,
> I'd actually regard that as unsafe <vbg> Think about it. Most modern PC's have a DVD reader but .... True! Actually I don't own a BD-device neither. No need for that at the moment. But I enjoy the BD for watching films on my big Plasma screen. ![]() Uli |
Thu, Oct 8 2009 9:15 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Uli
>But I enjoy the BD for watching films on my big Plasma screen. ![]() Rented I hope. The films I mean. The cost of purchase in teh UK is horrendous, and from what I've seen the quality improvement isn't worth the extra cash. Roy Lambert |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |