I totally agree... Seems like when users say SQLite is slower than "xyz...", they are using a high level driver based interface instead of using a "c" based driver program to really test what SQLite is doing. I have written tests at the "c" level for both MySQL and SQLite and SQLite is generally much faster. The MySQL overhead is probably due to tcp/ip communication... Now where SQLite seems to slow down is when the database contains over a gigabyte of data. Hopefully SQLite ver 3.xx will fix that...
-----Original Message----- From: Jimmy Lantz [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 14, 2004 1:39 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [sqlite] MySQL / SQLite At 19:32 2004-04-14, you wrote: >>Yes, but are mysql_query and sqlite_query really doing the same thing? It >>is quite possible that mysql_query doesn't actually perform the complete >>query, while sqlite_query does. I think a better test would be to do the >>query and then step through all of the results, doing something with each >>row. What is the time difference for that? > >Ok: > >$array = array(); >include("../cardsearch/setMySQL.php"); >$erg = mysql_query("SELECT * FROM speedtest WHERE text5 LIKE '%a%'"); >while($row=mysql_fetch_row($erg)) $array[] = $row; > >$array = array(); >$db = sqlite_open("speedtest.sqlite"); >$result = sqlite_query($db, "SELECT * FROM speedtest WHERE text5 LIKE '%a%'"); >while($row=sqlite_fetch_array($result)) $array[] = $row; > >MySQL: 0.24748015403748 >SQLite: 0.68342804908752 > >$array = array(); >$db = sqlite_open("speedtest.sqlite"); >$result = sqlite_unbuffered_query($db, "SELECT * FROM speedtest WHERE >text5 LIKE '%a%'"); >while($row=sqlite_fetch_array($result)) $array[] = $row; > >MySQL: 0.23681807518005 >SQLite: 0.64980888366699 > >I ran it several times, of course. I think there might be some work needed on the PHP implementation of SQLite (marked as experimental) Whereas the MySQL implementation has had years to mature and improve. Do your tests using the CLI instead and see if you get the same. / Jimmy >-hannes > > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ------------------------------------------------------------ This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately. Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen. ============================================================
