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