Jason Pruim
lists@xxxxxxxxxxxxxxxxxxxx
On Oct 25, 2011, at 6:35 PM, Jim Giner wrote:
> Again why even do a detail query? Nobody is going to examine pages and pages and etc.
> Do a summary qry if u just need a count - no pagination there
> jg
The bosses wanted them to be able to page through the results... But I might bring that up to them again... Working with 89 million records (With the number going up and expanding in the future) could cause lots of issues in the long run...
>
> On Oct 25, 2011, at 6:26 PM, Jason Pruim <lists@xxxxxxxxxxxxxxxxxxxx> wrote:
>
>>
>> Jason Pruim
>> lists@xxxxxxxxxxxxxxxxxxxx
>>
>>
>>
>> On Oct 25, 2011, at 10:51 AM, Jim Giner wrote:
>>
>>> I disagree. It's not about "tuning the queries", it is more about the appl.
>>> design that currently thinks it SHOULD do such huge queries.
>>>
>>> My approach would be to prompt the user for filtering criteria that
>>> automatically would reduce the result set size. Although at this time I
>>> believe the OP mentioned that the db is just telephone numbers so that
>>> doesn't leave much room for filter-criteria.
>>>
>>>
>>
>> Yes it is just phone numbers... The only select that I'm running on the entire site is related to the pagination... A simple:
>> $sqlCount = "SELECT COUNT(*) FROM main WHERE state = '{$state}'";
>>
>> which limits it to everything inside the state... Unfortunately if you look at the possibilities, it's still quite a large dataset... 89 million :)
>>
>> The rest of the query's will be much more limited to areacode, exchange, and in some cases the full phone number... Maybe the better way to do it would be not to count the records.... But set a variable with the total count... That way I don't have to load all the data... The data amount won't change alot... Easy enough to set a variable... Just need to see if I can integrate that with the pagination...
>>
>> Back to the drawing board! :)
>>
>>
>>
>>>
>>> --
>>> PHP General Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>
>>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
