Data load slow on initial mysql requst
10 posts by 2 authors in: Forums > CMS Builder
Last Post: September 4, 2014 (RSS)
By nmsinc - September 3, 2014
I have a database with six fields and 8,000 plus records. The data within each record is massive.
The first request each day takes 30 to 45 seconds - each request thereafter takes only seconds as if the first request is caching the data.
See my list code below -- is there a better means to request this data in PHP?
Thanks - nmsinc
$where = "";
$where = "publishDate <= NOW()";
// load records
list($nebraska_countiesRecords, $nebraska_countiesMetaData) = getRecords(array(
'tableName' => 'nebraska_counties',
'perPage' => '12',
'where' => $where,
));
By claire - September 4, 2014
Hey there - yes, it caches after the first request.
Roughly how much information is contained in each record, and have you an estimate of the amount of information transferred in each request?
Claire Ryan
interactivetools.com
Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
By nmsinc - September 4, 2014 - edited: September 4, 2014
Hi Claire,
I have 8000 @ 332 total Mib
Thanks - nmsinc
By claire - September 4, 2014
Wow, that is a lot of information! Realistically, there's no way to improve the load time unless you cut down on the info being pulled. Do you need every field from those records on that page?
Claire Ryan
interactivetools.com
Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
By nmsinc - September 4, 2014
Hi Claire,
Sorry I misquoted and corrected my last post as I'm posting while away from my office - I have 8000 @ 332 total Mib - if you do the math the data per record is no larger than 12 small page loads and on a 30 mg pipeline should be very quick!
Thanks - nmsinc
By claire - September 4, 2014
That works out to about 500KB then. Not a huge amount of information, but could be problematic depending on how it's being pulled from the database.
Can you show me the page where this is being loaded? I can do some analysis and see where the slowdown is happening.
Claire Ryan
interactivetools.com
Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
By nmsinc - September 4, 2014 - edited: September 4, 2014
HI Claire,
See attached page!
Thanks - nnmsinc
By claire - September 4, 2014
Sorry, I should be more specific - I need to see the live page, not the code itself. Can you send me a link to it?
Claire Ryan
interactivetools.com
Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
By nmsinc - September 4, 2014
Can you provide a support link as the page is password protected!
Thanks - nmsinc
By claire - September 4, 2014
Sure - please open a ticket using this form: https://www.interactivetools.com/support/email_support_form.php
Claire Ryan
interactivetools.com
Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/