pdb list very slow to load in frontend after update

Andy,

Something is definitely holding the page up…but unless you have your PHP max_execution_time set to over 90 seconds, it can’t be the plugin, you’d get a timeout error.

Did you try a test page on the same site that is a simple page with just the list?

500 errors usually indicate a misconfiguration of the server or possibly a corrupt file. You could try re-installing the plugin (don’t go through the delete process, just download the plugin and replace the files with the downloaded ones)

–Roland

When I mentioned the misconfiguration, I was talking about the 500 error.

It’s true I have not done extensive testing with large databases, so I don’t know what would cause the holdup. The database handling in the latest version should be better, not worse. In order to be able to comment intelligently on what’s happening for you, I’d have to run some tests, and I don’t have a large database to test it with at the moment.

What I do know is I have a number of users who are using much larger databases with no speed problems, so there is likely something about your situation that is different.

Is the database local to the website? How does the database you’re using on the site with 1.3.7 differ from the database you’re showing me that’s slow? If they’re the same, how did you copy it? Some kind of problem could have been introduced to the database at some point, possibly.

That you can’t export the CSV is curious…500 errors are not what you usually see from problems with the PHP code, usually it’s the server configuration that causes that kind of error from the server. The export may be triggering a security protocol, for instance. Have you had a look at your PHP error log or access logs to see if there’s any hints there?

Here’s what I suggest. Export (and backup) your database from your database application (like PHPMyAdmin) and save it as an sql dump. Now, take out half the records and see if there is an improvement. If it’s a bit faster, but still slow, it’s a problem affecting lots of records or the plugin itself. If it’s still the same or suddenly very fast, there is most likely a problem with one or a few records.

What I am going to do is put together a large database for testing purposes and see what the plugin does with it.

JoshBow,

If you can include a link to the page, it would be a lot easier to see what’s going on. There really isn’t any general reason why this would happen, so I would need some details to offer some help.

JoshBow,

Curious. No idea. I’d really have to go in and set in some debugging code to see what the holdup is.

Is this site live? Are you willing to email me a login so I can debug it? I’d like to know about it if there is a problem with the plugin.

–Roland

JoshBow,

I have to admit I know little about this, and I haven’t tested the plugin at all in a networked setup. I suppose it could be the source of the slow response…The queries themselves shouldn’t be the problem, they are working efficiently on much larger databases.

I would look at the MySQL server response time after the list queries were made. There are two of them: one that just counts the records and the next that actually gets the data for one page of records. Can’t think of much else it would be. Have you looked at your PHP error logs?

JoshBow,

OK, this is good info. What’s happening is I’m using CURL to validate the images, and I guess it can be slow to respond. This is new in 1.4 so looks like I need to find a way to optimize this or avoid using CURL if it’s not necessary.

Can you tell me what your setting for “File Upload Location” is?