Jay A. Kreibich wrote:
>> >Are you using a 32 bit or 64 bit process.
>>
>> 32, but it does not matter to the problem.
>
> When you give examples like "PRAGMA cache_size = 1000;", or 10M
> pages which would take something on the order of 15 GB of memory to
> service with the default 1K
On Mon, Apr 14, 2008 at 09:51:40AM +0200, Ralf Junker scratched on the wall:
> >> * OPTION 1: PRAGMA cache_size = 1000;
> >>
> >> Advantage: SQLite will use ample memory, but no more than that.
> >>
> >> Disadvantage: Difficulty to establish exact memory requirements in
> >> advance. The
Dan,
many thanks for the quick response and detailed answers. However, a question or
two still puzzle me.
>> * OPTION 1: PRAGMA cache_size = 1000;
>>
>> Advantage: SQLite will use ample memory, but no more than that.
>>
>> Disadvantage: Difficulty to establish exact memory requirements in
Roger Binns wrote:
>Are you using a 32 bit or 64 bit process.
32, but it does not matter to the problem.
>Also is there a requirement to create the database in the filesystem?
Yes.
>If not you could ensure your swap is sufficiently large (I use a mininmum of
>16GB on my machines :-) and
On Apr 14, 2008, at 5:53 AM, Ralf Junker wrote:
> I need to create a huge database (about 6 GB, more than 6 mio
> records, blobs, and FTS text) in as little time as possible. Since
> memory is the key to speed, I try to use as much memory as is
> available. However, there is the danger of
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ralf Junker wrote:
> I need to create a huge database (about 6 GB, more than 6 mio records, blobs,
> and FTS text) in as little time as possible. Since memory is the key to
> speed, I try to use as much memory as is available. However, there is the
I need to create a huge database (about 6 GB, more than 6 mio records, blobs,
and FTS text) in as little time as possible. Since memory is the key to speed,
I try to use as much memory as is available. However, there is the danger of
running out of memory. This is where memory usage control
7 matches
Mail list logo
