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,
  ));

nmsinc

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 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

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

nmsinc

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

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/