Re: [sqlite] SQLite scalability

Valentin Davydov wrote: On Thu, Nov 21, 2013 at 11:43:32AM +0200, Baruch Burstein wrote: Hi all, I know SQLite is supposed to support DB sizes in the TB (I think the default configuration can reach 1TB). I am curious if anyone actually uses SQlite at anywhere near this. Yes. Does anyone use

Re: [sqlite] SQLite scalability

On Thu, Nov 21, 2013 at 11:43:32AM +0200, Baruch Burstein wrote: > Hi all, > > I know SQLite is supposed to support DB sizes in the TB (I think the > default configuration can reach 1TB). I am curious if anyone actually uses > SQlite at anywhere near this. Yes. > Does anyone use it regularly fo

Re: [sqlite] SQLite scalability

On Thu, 21 Nov 2013 11:43:32 +0200 Baruch Burstein wrote: > Hi all, > > I know SQLite is supposed to support DB sizes in the TB (I think the > default configuration can reach 1TB). I am curious if anyone actually uses > SQlite at anywhere near this. Does anyone use it regularly for DBs 500GB+ >

Re: [sqlite] Scalability.

On Fri, 14 Aug 2009 11:00:53 -0700, Dmitri Priimak wrote: >Kees Nuyt wrote: >> On Fri, 14 Aug 2009 07:24:31 -0700, Dmitri Priimak >> wrote: >> >>> Hi. >>> >>> I have a database with few simple tables. Database is updated regularly >>> and than distributed to the clients, which only use it for

Re: [sqlite] Scalability.

Kees Nuyt wrote: > On Fri, 14 Aug 2009 07:24:31 -0700, Dmitri Priimak > wrote: > >> Hi. >> >> I have a database with few simple tables. Database is updated regularly >> and than distributed to the clients, which only use it for reading. So, >> concurrency is not an issue. But the database is al

Re: [sqlite] Scalability.

On Fri, 14 Aug 2009 07:24:31 -0700, Dmitri Priimak wrote: >Hi. > >I have a database with few simple tables. Database is updated regularly >and than distributed to the clients, which only use it for reading. So, >concurrency is not an issue. But the database is already quite large. >The file is

Re: [sqlite] Scalability.

Thanks, a lot guys. I will run a few tests with dummy database populated with my target amount rows and will let you know results. I realize now that I seem to have some unfounded fear of large files (FOLF) :) Hopefully it will pass. -- Dmitri Priimak ___

Re: [sqlite] Scalability.

> Your only problem is that you're at Stanford and Dr Hipp was at > Duke so he hates you. Not much humor on this list, but you made my day :-) Very funny. -Clark ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mai

Re: [sqlite] Scalability.

On 14 Aug 2009, at 3:24pm, Dmitri Priimak wrote: > I have a database with few simple tables. Database is updated > regularly > and than distributed to the clients, which only use it for reading. > So, > concurrency is not an issue. But the database is already quite large. > The file is about

Re: [sqlite] Scalability.

On Fri, Aug 14, 2009 at 07:24:31AM -0700, Dmitri Priimak scratched on the wall: > I have a database with few simple tables. Database is updated regularly > and than distributed to the clients, which only use it for reading. So, > concurrency is not an issue. But the database is already quite lar

Re: [sqlite] Scalability.

On Fri, Aug 14, 2009 at 9:24 AM, Dmitri Priimak wrote: > Hi. > > I have a database with few simple tables. Database is updated regularly > and than distributed to the clients, which only use it for reading. So, > concurrency is not an issue. But the database is already quite large. > The file is ab

[sqlite] Scalability.

Hi. I have a database with few simple tables. Database is updated regularly and than distributed to the clients, which only use it for reading. So, concurrency is not an issue. But the database is already quite large. The file is about 2.6GB and one table has about 1,800,000 rows and another on