Pages that use MySQL hang when done loading

 
Post new topic   Reply to topic    Aprelium Forum Index -> Databases
View previous topic :: View next topic  
Author Message
Arem
-


Joined: 14 Aug 2007
Posts: 3

PostPosted: Tue Aug 14, 2007 10:07 pm    Post subject: Pages that use MySQL hang when done loading Reply with quote

When I load a page that uses mysql on my website (www.arem.us), the page loads quickly, but the web browser keeps "loading" for 4 or 5 more seconds. This does not happen on static HTML pages, or on PHP pages that do not use mysql. I have used abyss before, but I just purchased a new server and have begun having this problem.

Thanks for the help!
Back to top View user's profile Send private message Visit poster's website
Arem
-


Joined: 14 Aug 2007
Posts: 3

PostPosted: Tue Aug 14, 2007 10:09 pm    Post subject: Reply with quote

Having watched the server task manager closely, PHP takes several seconds to quit after the page has visibly finished loading. However, after 4 or 5 seconds, PHP will exit and then the browser will register that the page has loaded.
Back to top View user's profile Send private message Visit poster's website
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Thu Aug 16, 2007 4:30 pm    Post subject: Reply with quote

Arem,

The problem here is that PHP takes 4 or 5 seconds to stop. So we suggest checing yoru scripts to understand why there is such a delay. Do simple scripts such as the following exhibit the same behavior?

Code:
<?php
  phpinfo();
?>

_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
Arem
-


Joined: 14 Aug 2007
Posts: 3

PostPosted: Thu Aug 16, 2007 4:52 pm    Post subject: Reply with quote

Actually, I discovered the problem was a well documented PHP bug related to how it handles MySQL requests. Evidently, it occurs in every version of PHP after 5.2.1. Downgrading libmysql.dll to the version from PHP 5.2.1 fixed the problem.
Back to top View user's profile Send private message Visit poster's website
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Mon Aug 20, 2007 12:02 am    Post subject: Reply with quote

Arem,

Why aren't you using the new MySQLi library (and PHP extension) which comes by default with new PHP versions? It seems to work fine.
_________________
Support Team
Aprelium - http://www.aprelium.com
Back to top View user's profile Send private message Send e-mail
Immemiaplaype
-


Joined: 13 Jul 2011
Posts: 13
Location: United Kingdom

PostPosted: Tue Jan 03, 2012 4:12 am    Post subject: Pages that use MySQL hang when done loading Reply with quote

I am using the database library libDatabase which is using the revOpenDatabase command and this is where the application crashes Is it possible to create revlets from the Enterprise version of Runrev or do I have to use revMedia?

Thanks for your help
Back to top View user's profile Send private message Send e-mail ICQ Number
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Databases All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group