RE: [sqlite] Is SQLite Scalable to handle large data?

[Griggs, Donald]

 

-Original Message-
From: Bharath Booshan L [mailto:[EMAIL PROTECTED] 
Sent: Friday, July 27, 2007 4:31 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Is SQLite Scalable to handle large data?

Hello,

 I have been using SQLIte database for one of my application (stand
-alone).
It contains  12 Tables and, on average, there can be around 60 - 100
thousand of rows in one table and rest contains around 2000 rows of
information which is linked to former one.

 It is providing acceptable performance. Now we need to make this
application as Client-Server type and hence the Scalability, Concurrency
issues arises which were not at-most importance till now.

Is SQLite feasible enough to handle huge data assuring the concurrency?

Note: The application performs more SELECT operations, with limited
INSERT & UPDATE operations. So the Query results retrieval time should
be minimal.

Please provide some suggestions. I will provide more information if
needed.

Regards,
Bharath Booshan L.  
==
Hello, Bharath,

On the one hand, sqlite can indeed handle multi-million row tables in
some cases.

On the other hand, I think that many would say that your client-server
application, with significant requirements for concurrency, would be one
where sqlite might well be risky.  Something like Postgres, MySql, or
one of the conventional, commercial databases might fit your
requirements much better.

I note, however, that I'm far from being an expert in this -- perhaps
your application is an exception.

[opinions are mine, not my company's]



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Is SQLite Scalable to handle large data?

[Bharath Booshan L]

Hello,

 I have been using SQLIte database for one of my application (stand -alone).
It contains  12 Tables and, on average, there can be around 60 - 100
thousand of rows in one table and rest contains around 2000 rows of
information which is linked to former one.

 It is providing acceptable performance. Now we need to make this
application as Client-Server type and hence the Scalability, Concurrency
issues arises which were not at-most importance till now.

Is SQLite feasible enough to handle huge data assuring the concurrency?

Note: The application performs more SELECT operations, with limited INSERT &
UPDATE operations. So the Query results retrieval time should be minimal.

Please provide some suggestions. I will provide more information if needed.

Regards,

Bharath Booshan L.  



---
Robosoft Technologies - Come home to Technology

Disclaimer: This email may contain confidential material. If you were not an 
intended recipient, please notify the sender and delete all copies. Emails to 
and from our network may be logged and monitored. This email and its 
attachments are scanned for virus by our scanners and are believed to be safe. 
However, no warranty is given that this email is free of malicious content or 
virus.



-
To unsubscribe, send email to [EMAIL PROTECTED]
-