The planning transition rate is 1ms per 34-40Kb data, we only have one connection trying to write to the database. If we have two connection, will we running to database concurrency issue?
Thank you, Liang -----Original Message----- From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of David Raymond Sent: Friday, May 03, 2019 11:11 AM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: [EXTERNAL] Re: [sqlite] seeking information on the throughput requirement using Sqlite 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:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Zhu, Liang [AUTOSOL/ASSY/US] Sent: Friday, May 03, 2019 10:01 AM To: sqlite-users@mailinglists.sqlite.org 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 liang....@emerson.com<mailto:liang....@emerson.com> 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 sqlite-users@mailinglists.sqlite.org https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=jOURTkCZzT8tVB5xPEYIm3YJGoxoTaQsQPzPKJGaWbo&r=4Y1ZhFy9bpH-wvkl_u5WMmphQqcZcyyY0DFEINZ4E6I&m=xvOxbL_JVO6tRWa--sJ-ZwGPDKJduQVT6rMEECKOzXI&s=MtBAWF7aqxaFuFE8faLYasnpTy6PDvqy01KYmBrmCSg&e= _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org https://urldefense.proofpoint.com/v2/url?u=http-3A__mailinglists.sqlite.org_cgi-2Dbin_mailman_listinfo_sqlite-2Dusers&d=DwIGaQ&c=jOURTkCZzT8tVB5xPEYIm3YJGoxoTaQsQPzPKJGaWbo&r=4Y1ZhFy9bpH-wvkl_u5WMmphQqcZcyyY0DFEINZ4E6I&m=xvOxbL_JVO6tRWa--sJ-ZwGPDKJduQVT6rMEECKOzXI&s=MtBAWF7aqxaFuFE8faLYasnpTy6PDvqy01KYmBrmCSg&e= _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users