Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-21 Thread Simon Slavin
On 21 Nov 2010, at 11:46am, Kees Nuyt wrote: > 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 kno

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 Kees Nuyt
On Sun, 21 Nov 2010 13:08:31 +0200, "Lynton Grice" 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 know of? > Standar

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&quo

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 g

Re: [sqlite] SQLite really SLOW on Solaris?

2010-11-21 Thread Lynton Grice
is it was super fast just like 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]

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, m

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 t

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 cou

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 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 SQ