Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-19 Thread John Drescher
> What happens if you insert more than your RAM size into an in memory > database? > (I'm particularly interested in the Windows context). > Are we talking about 32bit windows? I mean under 32 bit windows the normal address space limit (without the /3GB switch and LARGEADDRESSAWARE link flag) is

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-19 Thread Jay A. Kreibich
On Tue, Apr 19, 2011 at 03:29:42PM +0100, Simon Slavin scratched on the wall: > > On 19 Apr 2011, at 2:58pm, Adam DeVita wrote: > > > Our application is typically implemented on a standard laptop PC. It seems > > that the symptoms displayed are consistent with what this list describes > > would

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-19 Thread Simon Slavin
On 19 Apr 2011, at 2:58pm, Adam DeVita wrote: > Our application is typically implemented on a standard laptop PC. It seems > that the symptoms displayed are consistent with what this list describes > would happen, so it looks like I can start thinking of how to write a > defence. It does

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-19 Thread Adam DeVita
Thanks for the responses. Our application is typically implemented on a standard laptop PC. It seems that the symptoms displayed are consistent with what this list describes would happen, so it looks like I can start thinking of how to write a defence. It does suddenly become very slow. I

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-19 Thread eLaReF
Talking as a Windows user only rather than an SQL expert (I'm not even good enough to call myself a beginner!) Are we talking about a small netbook type with only say 8GB of memory and no hard drive. If a Windows m/c has a hard drive, surely virtual memory (drive-swapping) comes into play? It

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-18 Thread Simon Slavin
On 18 Apr 2011, at 2:44pm, Adam DeVita wrote: > What happens if you insert more than your RAM size into an in memory > database? Windows doesn't really keep all its memory in actual RAM. It uses a 'page file' to allow it to send data it's not actually using right now to disk, and call it

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-18 Thread Black, Michael (IS)
Subject: EXT :Re: [sqlite] What happens if you insert more than your RAM size into an in memory database? You won't be able to insert. The statement will fail. Pavel On Mon, Apr 18, 2011 at 9:44 AM, Adam DeVita <adev...@verifeye.com> wrote: > Good day, > > What happens if you insert

Re: [sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-18 Thread Pavel Ivanov
You won't be able to insert. The statement will fail. Pavel On Mon, Apr 18, 2011 at 9:44 AM, Adam DeVita wrote: > Good day, > > What happens if you insert more than your RAM size into an in memory > database? > (I'm particularly interested in the Windows context). > >

[sqlite] What happens if you insert more than your RAM size into an in memory database?

2011-04-18 Thread Adam DeVita
Good day, What happens if you insert more than your RAM size into an in memory database? (I'm particularly interested in the Windows context). regards, Adam ___ sqlite-users mailing list sqlite-users@sqlite.org