Re: [AOLSERVER] SQLite driver (was) Re: Are the weekly chats officially dead?
Dossy wrote: On 2003.07.31, Wojciech Kocjan <[EMAIL PROTECTED]> wrote: It works faster than nsmysql, at least for me... The main problem is date/time/datetime... Yuck. Not to get all defensive, but are you saying the nssqlite driver is faster than the nsmysql driver, or that SQLite is faster than MySQL for what you're doing? No no no. I'm saying that SQLite is faster than mySQL. However, I did speed the driver up by some percentage (before that, SQLite+nssqlite it was comparable to mySQL+nsmysql :-). If the driver itself is faster, I'm curious how you did it. If SQLite is faster than MySQL for the operations you're interested in, well, that's not too surprising ... I'd have to do some heavy load testing to get some better idea whether it makes sense to use SQLite... Has anyone done it? -- WK -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
Re: [AOLSERVER] SQLite driver (was) Re: Are the weekly chats officially dead?
On 2003.07.31, Wojciech Kocjan <[EMAIL PROTECTED]> wrote: > > It works faster than nsmysql, at least for me... The main problem is > date/time/datetime... Yuck. Not to get all defensive, but are you saying the nssqlite driver is faster than the nsmysql driver, or that SQLite is faster than MySQL for what you're doing? If the driver itself is faster, I'm curious how you did it. If SQLite is faster than MySQL for the operations you're interested in, well, that's not too surprising ... -- Dossy -- Dossy Shiobara mail: [EMAIL PROTECTED] Panoptic Computer Network web: http://www.panoptic.com/ "He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on." (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
[AOLSERVER] SQLite driver (was) Re: Are the weekly chats officially dead?
Roberto Mello wrote: - An SQLite driver (hopefully I'll get that working soon). This one is actually tricky. In order to use SQLite in production enviroment, you need to catch SQLITE_SCHEMA errors and reeval the query. If you want to experiment, here's my beta driver - http://www.zoro2.org/_chwilowe/nssqlite-beta.tar.gz It seems to work stable on my laptop... Even has no problems when another thread is doing CREATE TABLE/DROP TABLE - try doing the same with your driver ;-) It works faster than nsmysql, at least for me... The main problem is date/time/datetime... Yuck. -- WK -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.