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: Reducing the size of TEXT and BLOB fields


> Rob Lebowitz wrote:
> Are there any tricks to making blob fields smaller in Instant DB???

Are you using this on a FAT filesystem?  If so, the clustering will
round up the size of every file to the next multiple of the filesystem's
cluster size (which can be as large as 32KB).  This overhead adds up if
you have thousands of records with TEXT or BLOB fields.  I recommend
using NTFS if you must use a Microsoft OS, since it doesn't use the same
clustering behavior on large drives.  Of course UNIX & Linux use 32-bit
filesystems and don't do clustering like FAT either.

-- 
Bill Karwin (bill@lutris.com)
Application Architect - Lutris Technologies Inc.
-----------------------------------------------------------------------------
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.