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] -----------------------------------------------------------------------------
