Jason Pruim wrote:
Given the following 2 queries:
SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}';
SELECT DISTINCT areacode FROM main;
The second displays ALOT faster Like by minutes... the first one is
what I really want though Currently working with a
David McGlone da...@dmcentral.net wrote:
places.sqlite is mozilla's bookmarks db and I was trying to read this
db, but so far I've been unsuccessful.
sqlite ver: 2.8.17
PHP version: PHP 5.3.3-1ubuntu9.6 with Suhosin-Patch
php5-sqlite: 5.3.3-1ubuntu9.6
Okay, first off, mozilla uses sqlite3,
Jason Pruim li...@pruimphotography.com wrote:
Given the following 2 queries:
SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}';
SELECT DISTINCT areacode FROM main;
The second displays ALOT faster Like by minutes... the first one is what
I really want
Try running this : http://mysqltuner.pl/mysqltuner.pl
If the server has been up for over 24hrs it gives a lot of good insight and
things to try tuning wise as a starting point. It'll uncover a lot of
common configuration issues or MySQL server level bottlenecks.
-Dan
(apologizes for the top
Didn't the OP begin this very same subject a month ago?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
From: joker_mos...@hotmail.com
To: phps...@gmail.com
Date: Tue, 29 Nov 2011 23:07:13 -0500
CC: phildob...@gmail.com; php-db@lists.php.net
Subject: Re: [PHP-DB] Problem with mysql and php
Le 2011-11-28 à 22:38, Bastien Koert phps...@gmail.com a écrit :
On Mon, Nov 28, 2011 at
On Tue, 2011-11-29 at 16:31 -0600, Tamara Temple wrote:
David McGlone da...@dmcentral.net wrote:
places.sqlite is mozilla's bookmarks db and I was trying to read this
db, but so far I've been unsuccessful.
sqlite ver: 2.8.17
PHP version: PHP 5.3.3-1ubuntu9.6 with Suhosin-Patch
Jim,
Similar yes... But this was specifically about replacing distinct with
something since it was taking WAY to long...
But it did evolve into a very similar conversation :)
Jason Pruim
pru...@gmail.com
On Nov 29, 2011, at 6:25 PM, Jim Giner wrote:
Didn't the OP begin this very same