Display delay

m-naut 03 Mar, 2011
I’ve written a query and been able to access data in a Chrono-connectivity database filled with data input from website users. Results seemed to display OK until I noticed that new entries weren’t being displayed as they are submitted after the display page was refreshed. It didn’t occur to me that the connection could be anything but dynamic and the query would present all data in the db. When I checked the next day, the form input from the previous day was present. Is there something in the connection or query code that may be causing this delay?
Any thoughts you may share are appreciated.
Thanks, John
include_once("configuration.php");

$jconf = new JConfig();

$myconn = mysql_connect($jconf->host,$jconf->user,$jconf->password) or die(mysql_error());
mysql_select_db($jconf->db,$myconn);

$myquery = "select name, location, recordtime from ".$jconf->myjoomla_db."jos_chronoforms_my_form_db order by recordtime DESC";

$result = mysql_query($myquery,$myconn) or die (mysql_error());

$sql = mysql_fetch_array($result);
GreyHead 03 Mar, 2011
Hi John,

I've moved this from the ChronoComments to the ChronoForms forum.

Nothing in ChronoForms adds any delays like that. Is it possible you have caching turned on for your site? That would have a similar effect.

Bob
This topic is locked and no more replies can be posted.