Re: [sqlite] SQLite performance with lots of data

2009-10-05 Thread Simon Slavin
On 5 Oct 2009, at 8:02am, Keith Roberts wrote: > On Sun, 4 Oct 2009, Simon Slavin wrote: > >> But note that the fields of the row are stored in (more or less) a >> list. So accessing the 20th column takes twice (-ish) as long as >> accessing the 10th column. If you make a table with 100 columns

Re: [sqlite] SQLite performance with lots of data

2009-10-05 Thread Keith Roberts
On Sun, 4 Oct 2009, Simon Slavin wrote: > To: General Discussion of SQLite Database > From: Simon Slavin > Subject: Re: [sqlite] SQLite performance with lots of data > > > On 4 Oct 2009, at 6:11pm, Cory Nelson wrote: > >> On Fri, Oct 2, 2009 at 12:34 PM, Cory Nelson

Re: [sqlite] SQLite performance with lots of data

2009-10-04 Thread Simon Slavin
On 4 Oct 2009, at 6:11pm, Cory Nelson wrote: > On Fri, Oct 2, 2009 at 12:34 PM, Cory Nelson > wrote: >> On Fri, Oct 2, 2009 at 9:45 AM, Francisc Romano >> wrote: >>> Wow. I did not expect such a quick answer... >>> Is there somewhere I can read exactly how fast and how big >>> databases S

Re: [sqlite] SQLite performance with lots of data

2009-10-04 Thread Cory Nelson
On Fri, Oct 2, 2009 at 12:34 PM, Cory Nelson wrote: > On Fri, Oct 2, 2009 at 9:45 AM, Francisc Romano wrote: >> Wow. I did not expect such a quick answer... >> Is there somewhere I can read exactly how fast and how big databases SQLite >> can take, please? > > SQLite uses a b+tree internally, whi

Re: [sqlite] SQLite performance with lots of data

2009-10-02 Thread Cory Nelson
On Fri, Oct 2, 2009 at 9:45 AM, Francisc Romano wrote: > Wow. I did not expect such a quick answer... > Is there somewhere I can read exactly how fast and how big databases SQLite > can take, please? SQLite uses a b+tree internally, which is logarithmic in complexity. Every time your dataset doub

Re: [sqlite] SQLite performance with lots of data

2009-10-02 Thread Francisc Romano
Very good idea! Thank you! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite performance with lots of data

2009-10-02 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Francisc Romano wrote: > how big databases SQLite can take, please? Someone told me recently they have 37GB and 66 million rows in their data set. Another user is using the virtual table functionality together with synthetic indices to optimise worki

Re: [sqlite] SQLite performance with lots of data

2009-10-02 Thread P Kishor
On Fri, Oct 2, 2009 at 11:45 AM, Francisc Romano wrote: > Wow. I did not expect such a quick answer... > Is there somewhere I can read exactly how fast and how big databases SQLite > can take, please? See http://www.sqlite.org/limits.html for "how big." You will have to do your own measurements f

Re: [sqlite] SQLite performance with lots of data

2009-10-02 Thread Francisc Romano
Wow. I did not expect such a quick answer... Is there somewhere I can read exactly how fast and how big databases SQLite can take, please? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite performance with lots of data

2009-10-02 Thread P Kishor
On Fri, Oct 2, 2009 at 11:42 AM, Francisc Romano wrote: > Hello! > > I am not entirely certain this is the right way to proceed, but I haven't > been able to find the appropriate official SQLite forum (if one exists). > I want to create a rather complex AIR application that will have to deal > wit

[sqlite] SQLite performance with lots of data

2009-10-02 Thread Francisc Romano
Hello! I am not entirely certain this is the right way to proceed, but I haven't been able to find the appropriate official SQLite forum (if one exists). I want to create a rather complex AIR application that will have to deal with a massive database. My question is: Is SQLite capable of dealing