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: [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

RE: [sqlite] sqlite performance variationin linux and windows

2005-02-27 Thread Ionut Filip
ith 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 variationin li

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 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 Ionut Filip
, February 25, 2005 2:05 PM To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: 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.

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