Within a single transaction SQLite can do things very quickly. But a reminder that there can be only 1 write transaction happening at a time. So my questions are: What is the planned _transaction_ rate? And how many different connections will be trying to write at once?
-----Original Message----- From: sqlite-users [mailto:[email protected]] On Behalf Of Zhu, Liang [AUTOSOL/ASSY/US] Sent: Friday, May 03, 2019 10:01 AM To: [email protected] Subject: [sqlite] seeking information on the throughput requirement using Sqlite Hi Sqlite experts, In my current project, we have the need to inserting and deleting data to and from the database between 1 and 10 ms for 24/7. I am seeking the clarification on the following questions 1. what is the throughput requirements are possible using Sqlite API?, in other words, what is the max speed can my inserting and deleting operation be? 2. When we inserting and deleting data at the speed mentioned above, what kind database maintenance do we need to do to maintain the performance of the database? 3. How is constant deleting and insert effect the database performance? Thank you, Liang Zhu | Lead Software Engineer | Branson Ultrasonics Emerson Automation Solutions | 41 Eagle Road | Danbury, CT 06810 | USA T (203) 796-2235 | F (203) 796-0380 [email protected]<mailto:[email protected]> The information contained in this message is confidential or protected by law. If you are not the intended recipient, please contact the sender and delete this message. Any unauthorized copying of this message or unauthorized distribution of the information contained herein is prohibited. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
