On Aug 13, 2010, at 8:41 PM, Max Vlasov wrote:
> On Fri, Aug 13, 2010 at 1:38 PM, Max Vlasov
> wrote:
>
>>
>> I can approximately calculate, how big the new database will grow. Is
>>> there a way to tell SQLite to reserve an inital space or numer of
>>> pages
>>> instead of letting the datab
On Fri, Aug 13, 2010 at 1:38 PM, Max Vlasov wrote:
>
> I can approximately calculate, how big the new database will grow. Is
>> there a way to tell SQLite to reserve an inital space or numer of pages
>> instead of letting the database file grow again and again?
>>
>
>
> Thought about this recentl
> I can approximately calculate, how big the new database will grow. Is
> there a way to tell SQLite to reserve an inital space or numer of pages
> instead of letting the database file grow again and again?
>
Thought about this recently. Another idea is to tweak VFS. Since xWrite
method is suppos
>
> On 12 Aug 2010, at 12:37pm, Pavel Ivanov wrote:
>
>>> Here I (or we) think of the cycles the system needs when the small
>>> niche
>>> of the initial database is exhausted and it has to look for another
>>> free
>>> block on the filesystem. If you can tell the system in advance, how big
>>> th
On 12 Aug 2010, at 12:37pm, Pavel Ivanov wrote:
>> Here I (or we) think of the cycles the system needs when the small niche
>> of the initial database is exhausted and it has to look for another free
>> block on the filesystem. If you can tell the system in advance, how big
>> the niche has to be
TeDe escribió:
> Hello,
>
> I want to import a big subset of data from one database to a new one. I
> attach the two databases together and use
>
> insert into customers select * from source.customers where name LIKE 'x%'
>
> I can approximately calculate, how big the new database will grow. Is
> The same with STL vectors: initializing it with a size is faster than
> growing it element by element.
That's pretty bad comparison. Initializing of vector with size is
faster because it doesn't have to copy all elements later when it
reallocates its memory. File system doesn't work that way, it
Am 12.08.2010 13:16, schrieb Martin.Engelschalk:
> Am 12.08.2010 13:04, schrieb TeDe:
>> Am 12.08.2010 12:16, schrieb Martin.Engelschalk:
>>> Am 12.08.2010 12:08, schrieb TeDe:
Hello,
I want to import a big subset of data from one database to a new one. I
attach the two da
Hello Pawel,
you made some good points. I'm still in the stage of evaluation, I don't
claim to know, its faster. But I saw that behavior on a filemanger: when
you copy a large file, it immediately reseveres the whole space. The
same with STL vectors: initializing it with a size is faster than
gro
Am 12.08.2010 13:04, schrieb TeDe:
> Am 12.08.2010 12:16, schrieb Martin.Engelschalk:
>> Am 12.08.2010 12:08, schrieb TeDe:
>>>Hello,
>>>
>>> I want to import a big subset of data from one database to a new one. I
>>> attach the two databases together and use
>>>
>>> insert into customers se
Am 12.08.2010 12:16, schrieb Martin.Engelschalk:
>
> Am 12.08.2010 12:08, schrieb TeDe:
>> Hello,
>>
>> I want to import a big subset of data from one database to a new one. I
>> attach the two databases together and use
>>
>> insert into customers select * from source.customers where name LIKE
k IO or CPU cycles if
> it runs out of pages.
>
> --Original Message--
> From: Pavel Ivanov
> Sender: sqlite-users-boun...@sqlite.org
> To: General Discussion of SQLite Database
> ReplyTo: General Discussion of SQLite Database
> Subject: Re: [sqlite] Reserve database pages
&
Database
ReplyTo: General Discussion of SQLite Database
Subject: Re: [sqlite] Reserve database pages
Sent: Aug 12, 2010 06:20
> I can approximately calculate, how big the new database will grow. Is
> there a way to tell SQLite to reserve an inital space or numer of pages
> instead of le
> I can approximately calculate, how big the new database will grow. Is
> there a way to tell SQLite to reserve an inital space or numer of pages
> instead of letting the database file grow again and again? I'm looking
> for a way to speed up the import.
Why do you think that this kind of function
Am 12.08.2010 12:08, schrieb TeDe:
> Hello,
>
> I want to import a big subset of data from one database to a new one. I
> attach the two databases together and use
>
> insert into customers select * from source.customers where name LIKE 'x%'
>
> I can approximately calculate, how big the new da
Hello,
I want to import a big subset of data from one database to a new one. I
attach the two databases together and use
insert into customers select * from source.customers where name LIKE 'x%'
I can approximately calculate, how big the new database will grow. Is
there a way to tell SQLite to
16 matches
Mail list logo
