Re: [sqlite] what is the right cache_size for sqllite version 3.5.9
Thanks! I will do so. JP From: P Kishor To: General Discussion of SQLite Database Sent: Monday, April 20, 2009 5:18:27 PM Subject: Re: [sqlite] what is the right cache_size for sqllite version 3.5.9 On Mon, Apr 20, 2009 at 7:13 PM, Joanne Pham wrote: > I haven't test with different sizes at all? In other words, what Roger is gently trying to tell you is to test yourself before asking. You are the best judge of your conditions, your machines, your application. Testing is the surest way to find out the most appropriate answer for your situation. Change the cache_size then test. Then change again and test. Soon you will know the answer. You can then come back and ask the list, providing results of your test, and then folks might be able to guide to a better solution. > JP > > > > > > From: Roger Binns > To: General Discussion of SQLite Database > Sent: Monday, April 20, 2009 5:11:48 PM > Subject: Re: [sqlite] what is the right cache_size for sqllite version 3.5.9 > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Joanne Pham wrote: >> It it the right size for the cache_size? My applications have a lot of >> writes operations and can be up to millions rows per minutes. > > What results did you get when you did your testing with different sizes? > > Roger > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.9 (GNU/Linux) > > iEYEARECAAYFAkntDz0ACgkQmOOfHg372QShOgCghMA55nGhZJTj4EvjFNZ4sf7c > XKQAnjL5MLb6W4rkNfBJu3mS6nEdCAtP > =Vfdz > -END PGP SIGNATURE- > ___ > 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-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
Re: [sqlite] what is the right cache_size for sqllite version 3.5.9
On Mon, Apr 20, 2009 at 7:13 PM, Joanne Pham wrote: > I haven't test with different sizes at all? In other words, what Roger is gently trying to tell you is to test yourself before asking. You are the best judge of your conditions, your machines, your application. Testing is the surest way to find out the most appropriate answer for your situation. Change the cache_size then test. Then change again and test. Soon you will know the answer. You can then come back and ask the list, providing results of your test, and then folks might be able to guide to a better solution. > JP > > > > > > From: Roger Binns > To: General Discussion of SQLite Database > Sent: Monday, April 20, 2009 5:11:48 PM > Subject: Re: [sqlite] what is the right cache_size for sqllite version 3.5.9 > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Joanne Pham wrote: >> It it the right size for the cache_size? My applications have a lot of >> writes operations and can be up to millions rows per minutes. > > What results did you get when you did your testing with different sizes? > > Roger > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.9 (GNU/Linux) > > iEYEARECAAYFAkntDz0ACgkQmOOfHg372QShOgCghMA55nGhZJTj4EvjFNZ4sf7c > XKQAnjL5MLb6W4rkNfBJu3mS6nEdCAtP > =Vfdz > -END PGP SIGNATURE- > ___ > 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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] what is the right cache_size for sqllite version 3.5.9
I haven't test with different sizes at all? JP From: Roger Binns To: General Discussion of SQLite Database Sent: Monday, April 20, 2009 5:11:48 PM Subject: Re: [sqlite] what is the right cache_size for sqllite version 3.5.9 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joanne Pham wrote: > It it the right size for the cache_size? My applications have a lot of writes > operations and can be up to millions rows per minutes. What results did you get when you did your testing with different sizes? Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkntDz0ACgkQmOOfHg372QShOgCghMA55nGhZJTj4EvjFNZ4sf7c XKQAnjL5MLb6W4rkNfBJu3mS6nEdCAtP =Vfdz -END PGP SIGNATURE- ___ 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
Re: [sqlite] what is the right cache_size for sqllite version 3.5.9
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Joanne Pham wrote: > It it the right size for the cache_size? My applications have a lot of writes > operations and can be up to millions rows per minutes. What results did you get when you did your testing with different sizes? Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkntDz0ACgkQmOOfHg372QShOgCghMA55nGhZJTj4EvjFNZ4sf7c XKQAnjL5MLb6W4rkNfBJu3mS6nEdCAtP =Vfdz -END PGP SIGNATURE- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] what is the right cache_size for sqllite version 3.5.9
Hi All, I am currently using sqlite 3.5.9 and I have set the cache_size as below: sqlSt = sqlite3_exec(pDb, "PRAGMA cache_size = 2000 ", NULL, 0, &errMsg); It it the right size for the cache_size? My applications have a lot of writes operations and can be up to millions rows per minutes. Thanks, JP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users