Re: [sqlite] sqlite performance variationin linux and windows

2005-02-27 Thread D. Richard Hipp
On Sun, 2005-02-27 at 15:31 -0500, Clay Dowling wrote: > > > >Anyone using other compiler to build sqlite on Windows ? Maybe Borland ? > >I seems there is a lot o room for faster sqlite.dll by using other > >compiers than VC++ 6. We can run some tests to see which is faster ... > > > I thought I re

Re: [sqlite] sqlite performance variationin linux and windows

2005-02-27 Thread Clay Dowling
Ionut Filip wrote: Hi, So the VC++ 7.1 dll is much faster than the VC++ 6, up to 20% in some operations, and the "MS mixed dll load bug" is not a problem, assuming sqlite doesn't mix native code with managed .net code :). Anyone using other compiler to build sqlite on Windows ? Maybe Borland ? I se

RE: [sqlite] sqlite performance variationin linux and windows

2005-02-27 Thread Ionut Filip
; 'Keith Herold' Subject: RE: [sqlite] sqlite performance variationin linux and windows > -Original Message- > From: Keith Herold [mailto:[EMAIL PROTECTED] > Sent: Friday, February 25, 2005 3:57 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] sqlite performance

Re: [sqlite] sqlite performance variationin linux and windows

2005-02-25 Thread Roger Binns
build a version up to 10-15% faster I saw the same kind of speedup (and sometimes up to 25%) depending on if assertions are enabled. I believe they are enabled by default. Adding -DNDEBUG turns them off. Roger

RE: [sqlite] sqlite performance variationin linux and windows

2005-02-25 Thread Robert Simpson
> -Original Message- > From: Keith Herold [mailto:[EMAIL PROTECTED] > Sent: Friday, February 25, 2005 3:57 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] sqlite performance variationin linux and windows > > http://www.adtmag.com/article.

Re: [sqlite] sqlite performance variationin linux and windows

2005-02-25 Thread Keith Herold
http://www.adtmag.com/article.asp?id=7421 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vstechart/html/vcconMixedDLLLoadingProblem.asp It's been awhile since Iooked at this, but I distinctly remember reading from one of the product managers at MS that this wouldn't be fixed

Re: [sqlite] sqlite performance variationin linux and windows

2005-02-25 Thread Andrew Piskorski
On Fri, Feb 25, 2005 at 02:25:06PM -0800, Keith Herold wrote: > Well, MS has said that VC++ .NET has a serious multithreading issue; > a lot of companies are staying on VC6 for that reason. Keith, I wasn't aware of that. Could you point us to more info on the problem, please? -- Andrew Piskorsk

Re: [sqlite] sqlite performance variationin linux and windows

2005-02-25 Thread Keith Herold
Well, MS has said that VC++ .NET has a serious multithreading issue; a lot of companies are staying on VC6 for that reason. --Keith On Fri, 25 Feb 2005 23:47:32 +0200, Ionut Filip <[EMAIL PROTECTED]> wrote: > > Hi Appadurai, > > From my experience the stock sqlite.dll is not very fast. I guess

RE: [sqlite] sqlite performance variationin linux and windows

2005-02-25 Thread Ionut Filip
Hi Appadurai, >From my experience the stock sqlite.dll is not very fast. I guess it's build with VC++ 6. Using VC++ 7.1 I was able to build a version up to 10-15% faster, not a bad optimization for 0 lines of code :) . It was a little bigger, about +25%, but for desktop this is not a problem. I o

Re: [sqlite] sqlite performance variationin linux and windows

2005-02-24 Thread Chris Schirlinger
On 24 Feb 2005 at 19:08, Neelamegam Appadurai wrote: > Can anyone please help me how to increase the performance on windows > enviroment Have a look at this Wiki http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows Some basic things to be aware of in there with regards to Speed and Win

Re: [sqlite] sqlite performance variationin linux and windows

2005-02-24 Thread Ulrik Petersen
Hi, Neelamegam Appadurai wrote: Can anyone please help me how to increase the performance on windows enviroment One thing you can do is to increase the page size from 1024 to 4096. That seems to match either Windows' swapfile-pagesize or the default page size of NTFS (there is disagreement ove

[sqlite] sqlite performance variationin linux and windows

2005-02-24 Thread Neelamegam Appadurai
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 w