Re: Exporting large data from mysql to html using php
| From: | tamouse mailing lists | Date: | Tue, 25 Oct 2011 05:18:19 +0000 |
| Subject: | Re: Exporting large data from mysql to html using php | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-315417@lists.php.net to get a copy of this message | ||
On Mon, Oct 24, 2011 at 7:50 PM, Jason Pruim <lists@pruimphotography.com> wrote:
> I have about 89 million records in mysql... the initial load of the page takes 2 to 3 minutes,
> I am using pagination, so I have LIMIT's on the SQL query's... But they just aren't
> going fast enough...
>
> What I would like to do, is pull the data out of MySQL and store it in the HTML files, and then
> update the HTML files once a day/week/month... I can figure most of it out... BUT... How do I
> automatically link to the individual pages?
Does this help?
http://peeling.hubpages.com/hub/Generate_Static_HTML_Pages_From_A_Database