Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-21 Thread Lynton Grice
it was on Debian. Any ideas? Lynton -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Eric Smith Sent: 20 November 2010 09:13 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite really SLOW on Solaris? Lynton

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-21 Thread Simon Slavin
On 21 Nov 2010, at 10:10am, Lynton Grice wrote: in my queue implementation I add in a: sqlite3_sleep(1); Essentially I wanted to sleep for 1 millisecond between sends to the queue (in the send function itself), so that if the sender is sending too fast it allows receivers to get

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-21 Thread Lynton Grice
...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: 21 November 2010 12:23 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite really SLOW on Solaris? On 21 Nov 2010, at 10:10am, Lynton Grice wrote: in my queue implementation I add

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-21 Thread Kees Nuyt
On Sun, 21 Nov 2010 13:08:31 +0200, Lynton Grice lynton.gr...@logosworld.com wrote: Hi Simon, Yup, on Solaris I ran this and it was 1000 milliseconds for the following: int theReturn = sqlite3_sleep(1); Any way you know I can make it sleep on Solaris for 1 millisecond? Any other C tricks you

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-21 Thread Lynton Grice
Thanks Kees, much appreciated ;-) -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kees Nuyt Sent: 21 November 2010 01:47 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] SQLite really SLOW on Solaris? On Sun, 21 Nov 2010

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-21 Thread Simon Slavin
On 21 Nov 2010, at 11:46am, Kees Nuyt wrote: lynton.gr...@logosworld.com wrote: Hi Simon, Yup, on Solaris I ran this and it was 1000 milliseconds for the following: int theReturn = sqlite3_sleep(1); Any way you know I can make it sleep on Solaris for 1 millisecond? Any other C

[sqlite] SQLite really SLOW on Solaris?

2010-11-20 Thread Lynton Grice
Hi there, I compiled SQLite on Debain (VM) first using the following: /usr/local/bin/gcc -c -fPIC sqlite3.c /usr/local/bin/gcc -shared -o libsqlite3.so sqlite3.o And then I created my own shared lib using SQLite and when I use the lib on Debian it is SUPER FAST. Then I installed

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-20 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/20/2010 07:12 AM, Lynton Grice wrote: On Debian it processes a couple hundred messages per second, on Solaris using the SAME code it does like ONE message per second. One possible cause is the busy handler but this only applies if you have

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-20 Thread Lynton Grice
-users-boun...@sqlite.org] On Behalf Of Roger Binns Sent: 20 November 2010 07:31 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite really SLOW on Solaris? -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/20/2010 07:12 AM, Lynton Grice wrote: On Debian it processes a couple

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-20 Thread Eric Smith
Lynton Grice wrote: Many thanks for your feedback, much appreciated ;-) But why would that happen on Solaris and not Debian? Did you try it on real OSs not VMs? Are you sure the host OS is giving the same compute disk slices to the VMs? Any other differences in those mappings? Are the

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-20 Thread Lynton Grice
Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Eric Smith Sent: 20 November 2010 09:13 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQLite really SLOW on Solaris? Lynton Grice wrote: Many thanks for your feedback, much