Jim, The primary table in the database has 5 columns, and has at most about 4,000 entries during stress-testing. (Although in tests involving even only about 600 entries, the results were the same.) There are a few other tables that would be much smaller. Nothing that should stress any resources at all. System RAM is 20 GB.
-Vern ---------------------------------------------------------------- Vern Jensen Software Engineer Artificial Intelligence in Medicine (AIM) Program jens...@cshs.org<mailto:jens...@cshs.org> Office: 310-423-8148 :: Fax: 310-423-0173 On Aug 6, 2014, at 7:47 PM, Jim Callahan <jim.callahan.orla...@gmail.com<mailto:jim.callahan.orla...@gmail.com>> wrote: What is the system memory utilization? If the in-memory database overloads the real memory the frantic os virtual memory paging (thrashing) could slow everything down. >From your use scenario it sounds like your database shouldn't be that large, but how large is the database? and how large is the system ram? What percent of the ram is being used? Jim Callahan IMPORTANT WARNING: This message is intended for the use of the person or entity to which it is addressed and may contain information that is privileged and confidential, the disclosure of which is governed by applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this information is STRICTLY PROHIBITED. If you have received this message in error, please notify us immediately by calling (310) 423-6428 and destroy the related message. Thank You for your cooperation. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users