On Mon, Aug 20, 2007 at 10:40:35PM -0400, Nelly Yusupova wrote:
>
> I have a table that contains about 40,000 rows of job posting data.
... snip ...
> average query takes about 10 seconds to display in a browser, which is way
> too long.
40k rows is small. Searching is what databases excel at. Using XML is
crazy.
Use the EXPLAIN / DESCRIBE query keywords to get some very useful
information.
Also read up on how indexes work in the DBMS you're using. The MySQL
manual has a very good section on it, for example.
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
