Re: [sqlite] Question: Memory-Based Databases

[Tito Ciuro]

Thanks Pavel!

-- Tito

On May 10, 2011, at 11:12 AM, Pavel Ivanov wrote:

> Until you reach limit set by 'pragma cache_size' memory usage would be
> the same for in-memory database and on-disk database. When the size of
> your database grows beyond 'pragma cache_size' in-memory database
> starts to consume more memory than on-disk one, because it has nowhere
> to push pages out of the cache.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Question: Memory-Based Databases

[Pavel Ivanov]

> Is this true, or is the memory usage pretty much similar?

Until you reach limit set by 'pragma cache_size' memory usage would be
the same for in-memory database and on-disk database. When the size of
your database grows beyond 'pragma cache_size' in-memory database
starts to consume more memory than on-disk one, because it has nowhere
to push pages out of the cache.


Pavel


On Tue, May 10, 2011 at 9:18 AM, Tito Ciuro  wrote:
> Hello,
>
> I have been using memory-based databases (opened via :memory:) and 
> performance is great. However, one of the things I assumed with memory-based 
> databases was that memory usage would be higher than the temporary or 
> persistent databases stored on disk. Is this true, or is the memory usage 
> pretty much similar? I've perform a few tests with fairly small data sets and 
> I don't see a difference. Any ideas?
>
> Thanks,
>
> -- Tito
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Question: Memory-Based Databases

[Tito Ciuro]

Hello,

I have been using memory-based databases (opened via :memory:) and performance 
is great. However, one of the things I assumed with memory-based databases was 
that memory usage would be higher than the temporary or persistent databases 
stored on disk. Is this true, or is the memory usage pretty much similar? I've 
perform a few tests with fairly small data sets and I don't see a difference. 
Any ideas?

Thanks,

-- Tito
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users