results to no PHP/mySQL-file

trackz

Hi there I have this problem..

I'm working on a searchengine, with huge ammounts of records.. over 20.000 to start, and besides that a very busy site. (also +15.000 hits a day. or some queries over 1000 records will be returned

What I'm trying to do is to create a page that will post all results of such a query to a file that isn't connected to the database. This page has to be updated every say 30 minutes

What I mean is.. I don't want the database to be searched every time a page is opened. (the normal PHP-mySQL-function). A temporary PHP/HTML file will do fine

Is there a function in PHP that can handle this.
Hope to get a reply for this problem..

Regards,
Trackz

yelvington

Those aren't particularly high numbers in my view.

Any reason the normal PHP file i/o functions won't do what you want?

mp96brbj

So basically, you'd like to transfer the whole table into a PHP document, that would handle the queries by itself? The only way I see of doing this would be to output the table into a textfile which is then read by the PHP script, and that sounds just as power-consuming as doing the queries directly in MySQL. It doesn't sound like a worthwhile solution to me.

Maybe you could speed up the database by adding some clever indexes instead. Read this recent article:
http://www.phpbuilder.com/columns/tim20010110.php3