My recollection of using MPE was performance measured in furlongs per
fortnight and the need to do that allocation strictly to get contiguous
space to try to counter the dismal performance of the HPIB disks which
were boat anchors on some of the HP/3000's.
Fortunately we don't have to indulge
On Fri, 1 Dec 2006, John Stanton wrote:
I cannot see a reason for what you propose, but you could do it by brute
force and ignorance - populate the DB with 1 million rows then delete them
all to add all the space to the free pages list. Then your insertions will
use the freed pages, not
On Fri, Dec 01, 2006 at 08:35:24AM +0100, kamil wrote:
> I want to preallocate disk space for database. I have only one table with ~1
> milion entries, each entry takes about 30 bytes. Entries are added/removed
> but there is some maximum number of items, which can be put into the table
> at
I cannot see a reason for what you propose, but you could do it by brute
force and ignorance - populate the DB with 1 million rows then delete
them all to add all the space to the free pages list. Then your
insertions will use the freed pages, not fresh ones.
kamil wrote:
I want to
You could look at the Sqlite data structures and write a program to
build the free pages list. I still don't understand why you need to
pre-allocate space.
If you are using Linux or Unix you can make a file system of a fixed
size for the DB. On Windows you could partition the disk into a
kamil wrote:
I want to preallocate disk space for database. I have only one table with ~1
milion entries, each entry takes about 30 bytes. Entries are added/removed
but there is some maximum number of items, which can be put into the table
at the same time. Is it possible to allocate a fixed
"kamil" <[EMAIL PROTECTED]> wrote:
> I want to preallocate disk space for database. I have only one table with ~1
> milion entries, each entry takes about 30 bytes. Entries are added/removed
> but there is some maximum number of items, which can be put into the table
> at the same time. Is it
I want to preallocate disk space for database. I have only one table with ~1
milion entries, each entry takes about 30 bytes. Entries are added/removed
but there is some maximum number of items, which can be put into the table
at the same time. Is it possible to allocate a fixed disk space for
8 matches
Mail list logo