I’m with you Simon but the program I’m working on will probably only ever be used by me. I just like to try and do things properly as a means of learning. I’m using win64 with 16GB RAM and 512GB SSD so everything’s already fast. I only tested in win32 so I’d run out of memory a lot quicker.
________________________________ From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Simon Slavin <slav...@bigfraud.org> Sent: Friday, December 15, 2017 8:50:40 PM To: SQLite mailing list Subject: Re: [sqlite] What happens if an in memory database runs out of memory On 15 Dec 2017, at 8:36pm, x <tam118...@hotmail.com> wrote: > I’ll have to look into how to increase the in-memory pager cache. Before you do anything like that, ask yourself two questions: a) Is my program actually fast enough without any of these weird picky measures ? Or am I spending lots of time learning details of SQLite when I could be spending it improving my program’s functions ? b) Is the environment I’m developing under identical to those my program is going to work under ? You’re running under win32. Are all your users going to run under win32 or some going to be running win64 ? The two don’t do the same things at the same point. Don’t do lots of work and then have to tell people "My program doesn’t work on your computer because you’re running 64-bit Windows 10.". Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users