Re: Exporting large data from mysql to html using php

On 10/24/2011 5:50 PM, Jason Pruim wrote: > Now that I've managed to list 3 separate programming languages and somewhat tie it back > into php here's the question... > > 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? > > I have the site working when you pull it from MySQL... Just the load time sucks... Any > suggestions on where I can pull some more info from? :) > > Thanks in advance! > > > Jason Pruim > lists@pruimphotography.com > Jason, How large a data set are you starting with? How many records in all. Will you show us your DB schema? -- Jim Lucas http://www.cmsws.com/ http://www.cmsws.com/examples/ http://www.bendsource.com/ C - (541) 408-5189 O - (541) 323-9113 H - (541) 323-4219