Re[2]: [PHP] saving resource objects
| From: | Tom Rogers | Date: | Wed, 17 Dec 2003 02:45:59 +0000 |
| Subject: | Re[2]: [PHP] saving resource objects | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-172849@lists.php.net to get a copy of this message | ||
Hi,
Wednesday, December 17, 2003, 12:32:25 PM, you wrote:
ML> Thanks for the info, Tom. That explains it. I can't really run the query
ML> again because of time and the size of the database. There is currently over
ML> 200,000,000 records in some of the tables. The subsets I get are generally
ML> small. What my current thinking is, is to grab the info I need into a
ML> temporary table and just run my search against the temporary table (taking
ML> all records) and seeking to the correct position for display. I was trying
ML> to avoid this if the information about my previous query was available
ML> somewhere.
ML> Michael
With that many records a temp table is definitely the way to go :)
--
regards,
Tom