View previous topic :: View next topic |
Author |
Message |
Arem -
Joined: 14 Aug 2007 Posts: 3
|
Posted: Tue Aug 14, 2007 10:07 pm Post subject: Pages that use MySQL hang when done loading |
|
|
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 |
|
|
Arem -
Joined: 14 Aug 2007 Posts: 3
|
Posted: Tue Aug 14, 2007 10:09 pm Post subject: |
|
|
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 |
|
|
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Thu Aug 16, 2007 4:30 pm Post subject: |
|
|
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 |
|
|
Arem -
Joined: 14 Aug 2007 Posts: 3
|
Posted: Thu Aug 16, 2007 4:52 pm Post subject: |
|
|
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 |
|
|
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Mon Aug 20, 2007 12:02 am Post subject: |
|
|
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 |
|
|
Immemiaplaype -
Joined: 13 Jul 2011 Posts: 13 Location: United Kingdom
|
Posted: Tue Jan 03, 2012 4:12 am Post subject: Pages that use MySQL hang when done loading |
|
|
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 |
|
|
|