Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: unusual growing of table size


Jens

There's no table compacting mechanism as yet in IDB. The only way to compact
a table at present is to export its contents, drop it, recreate and
re-import. It's not as bad as it sounds, once you have a script for it you
can run it as often as needed. Something like:

set export "tmp.cvs" csvdelimited;
select * from tmp;
set export "null";

drop table tmp;
create table tmp (...);
import "tmp" from "tmp.cvs";

You might also want to look at the database property, searchDeletes. This
may produce more compact tables when all rows get updated. See

http://instantdb.enhydra.org/software/documentation/props.html

for details.


Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "Jens Panse" <jens.panse@EasternGraphics.com>
To: <instantdb@enhydra.org>
Sent: Monday, October 09, 2000 2:12 PM
Subject: InstantDB: unusual growing of table size


> There is an instantdb database with a table including about 1600
> entries. After a few update operations on all rows the size of this
> table grew from 2,5 MB to 7 MB. There are no indexes, no foreign keys,
> no triggers. The update operations simply changed the values of columns
> ( all double). Now the operations on this table are getting real slow.
> Is there something like VACUUM, to "clean" the table?
>
> Jens Panse
>
> --
> -[ ]-/\-(
> )-----------------------------------------------EasternGraphics-------
>
> Jens Panse
>
> http://www.EasternGraphics.com
> phone: +49 3677 678267
>
>
> --------------------------------------------------------------------------
---
> To unsubscribe from this mailing list, send email to majordomo@enhydra.org
> with the text "unsubscribe instantdb" in the body of the email.
> If you have other questions regarding this mailing list, send email to
> the list admin at owner-instantdb@enhydra.org.
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.