Php and RAM

gotornot

Hi All

I have a site that holds over 900k of products. I am searching on my db and its taking 10 seconds to search products and bring back results. I wondered if i stored the data in the ram the results would be instantanious.

Does anyone have any experience or could point me in the right direction of how to do this.

In an ideal world i would like the rsults to come back in aroun1/2 seconds.

Thanks for the help and advice in advance 🙂

bradgrafelman

First question would be: What are you using for your DBMS? Second would be: Are you sure you've properly optimized your schema based on that DBMS's guidelines/recommendations?

Depending upon your answer to the first question, your thread title might not even be relevant - it likely isn't PHP that needs to be made more memory-efficient but rather the DBMS.

NogDog

And a bit more specifically: not make the DBMS itself more efficient, but how you are using it more efficient. 😉

I'm guessing that at a minimum you may need to add some indexes on one or more columns used in WHERE and/or ORDER BY clauses within your query. The larger your data set becomes, the more impact proper indexing makes on query performance.

dalecosp

If it's MySQL, there's a script called "mysqltuner.pl" (written in PERL) for any PERL-enabled server environment; running it may help you do some "tuning" of the server.

Enabling the "slow queries log" is also worth it, probably.

If you have queries that you don't know what do, or, once you find queries in the slow log, run then through EXPLAIN.

MySQL also has some good tutorials ... I'll see if I can find a link to a webinar I attended.

sneakyimp

It may also be that the DBMS is fine but his script is fetching too many records at once and processing them all instead of just fetching what it needs.

Weedpacket

In other words we have a lot of speculation about vague possibilities, but nothing concrete. We don't even know what sort of "searching" is involved - for all we know it could be querying based on a lot of drop-down selections; filtering against a list of specific keywords; a full-text search of anything from short blurbs to full documents; an XML traversal, or something else.

annaharris

Your SQL queries might not be well optimized and thus it takes time to load the output. You should optimize your SQL queries.