[sqlite] Invitation to connect on LinkedIn
LinkedIn I'd like to add you to my professional network on LinkedIn. - Neelamegam Neelamegam Appadurai sss at Zoho Corporation India Confirm that you know Neelamegam Appadurai https://www.linkedin.com/e/isd/936554437/zokwXfFf/ -- (c) 2009, LinkedIn Corporation ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite_busy in multithreaded application
Hi, Though they were lot of discussion on this, I could not find solution in my case. To elaborate the happening. Let me say i have two threads 1.ReadThread 2. DeleteThread My ReadThread does the following. 1. Compile and Create SQLStatement 2. Generate QueryObject 3. Query and finalize . 4. Reset Statement and finalize statement. My DeleteThread 1.Compile and create SQLStatement 2. Do Delete 3. Reset and Finalize. I have implemented my lock mechanism which is such that Step2 and Step3 are inside Mylock(only one thread can access) so that Delete thread will not gain access to DB during the stage. I get SQLite_Busy, database is locked, from my deleteThread which can happen only between step 1 and step2 or between step 3 and step4 of read thread. Is it neccessary for me to have reset statement of readThread also inside lock. I am using CppSQLiteWrapper. Is it neccessary for me to have my lock before Step1 and unlock after Step4. Thanks for your time
Re: [sqlite] Re: sqlite performance variationin linux and windows
Hi Chris, Thanks for the detailed explanation, I will dig deeper into my code to see if there is anything wrong in the OS specific code in my appln. Anyway thanks for the support. appadurai On Fri, 25 Feb 2005 10:33:35 +0530, Neelamegam Appadurai <[EMAIL PROTECTED]> wrote: > Hi, > Thanks for the quick response and the interest you're showing, > I am testing the performance of linux and windows using > a. same testing data for both. > b. db schema is common for both. > c. though the test is conducted on two different machines but the > machine configurations are similar. > > Only consideration is at very few places jin the application, code is > platform dependent ie the api calls may differ based on the type of > OS, but this is also seldom used in our application. > But still, For the same application on windows, performance of sqlite > is slower compared to file system read or write which we were using > earlier. > Thanks once again for the reply, > appadurai > > > On Fri, 25 Feb 2005 15:28:23 +1100, Chris Schirlinger > <[EMAIL PROTECTED]> wrote: > > On 25 Feb 2005 at 9:38, Neelamegam Appadurai wrote: > > > > > Could anyone please give me reason for variation in performance > > > between linux and windows. > > > > How are you testing this performance? Do you have a program written > > in windows and another written for linux? If so, the code/mechanism > > of DB access may be the issue > > > > Is it the same phisical DB? Same schema? Same machine specs? Same > > amount of data? > > > > All those things could contribute. > > > > >
Re: [sqlite] Re: sqlite performance variationin linux and windows
Hi, Thanks for the quick response and the interest you're showing, I am testing the performance of linux and windows using a. same testing data for both. b. db schema is common for both. c. though the test is conducted on two different machines but the machine configurations are similar. Only consideration is at very few places jin the application, code is platform dependent ie the api calls may differ based on the type of OS, but this is also seldom used in our application. But still, For the same application on windows, performance of sqlite is slower compared to file system read or write which we were using earlier. Thanks once again for the reply, appadurai On Fri, 25 Feb 2005 15:28:23 +1100, Chris Schirlinger <[EMAIL PROTECTED]> wrote: > On 25 Feb 2005 at 9:38, Neelamegam Appadurai wrote: > > > Could anyone please give me reason for variation in performance > > between linux and windows. > > How are you testing this performance? Do you have a program written > in windows and another written for linux? If so, the code/mechanism > of DB access may be the issue > > Is it the same phisical DB? Same schema? Same machine specs? Same > amount of data? > > All those things could contribute. > >
[sqlite] Re: sqlite performance variationin linux and windows
Hi all, Thanks for your replies, I had changed the page_size to 4096 and followed the doc "performance tuning for windows" and made changes as per the doc. Though there was increase in performance, but the performance in windows when compared to linux is much low. Could anyone please give me reason for variation in performance between linux and windows. Once again thanks for the response. appadurai On Thu, 24 Feb 2005 19:08:26 +0530, Neelamegam Appadurai <[EMAIL PROTECTED]> wrote: > hi all, > I was using file in my application to store and read datas, Now i want > my application to use sqlite DB. > I compiled and installed sqlite db,version 3.0.8, in my linux system > as well as on a windows replacing the fileoperations . > The performance of sqlite against filesystem on linux machine was not > of much difference. > But in windows, the performance of sqlite against filesystem is > reduced by half, time taken to complete a task is doubled. > Can anyone please help me how to increase the performance on windows > enviroment and why the difference in performance > between linux and windows. > Thanks in advance > appadurai >
[sqlite] sqlite performance variationin linux and windows
hi all, I was using file in my application to store and read datas, Now i want my application to use sqlite DB. I compiled and installed sqlite db,version 3.0.8, in my linux system as well as on a windows replacing the fileoperations . The performance of sqlite against filesystem on linux machine was not of much difference. But in windows, the performance of sqlite against filesystem is reduced by half, time taken to complete a task is doubled. Can anyone please help me how to increase the performance on windows enviroment and why the difference in performance between linux and windows. Thanks in advance appadurai