DataAssist results page very slow to load

One of the DataAssist results pages in a client's CMS is very, very slow to load - anything up to 1.5 minutes on a superfast broadband connection. All other pages in the CMS load fine and I've checked on the Developers Console in Chrome and can't see what's causing the problem. Also ran error reporting and apart from a couple of duplicate session starts, which I've removed, there were no errors. Any idea what might be causing this? There are over 2,000 rows in the table but I wouldn't have thought that would be the issue?

I found out what was causing the trouble - I have a table in the database which records the successful login dates and times by each users. This table currently has over 27,000 entries and I had queried it as follows:

SELECT max(Login) as Login FROM users LEFT JOIN `LoginRecord` on users.user_email = LoginRecord.UserID

This is what was slowing everything down. I've taken that facility off the results page and was going to build it into the user detail page instead, however I can't actually select the table from the list of tables in the Recordset builder - it doesn't appear in the dropdown. Could this be because of its size?

Did you create an index on the Login column? That can greatly improve performance.

I'm not sure why the table wouldn't show are you using a local database for testing? Maybe it doesn't exist?

Hi Ray, I added an index to the Login column and all seems to be working fine now. I also realised why I thought the table wasn't showing - it was, but because the table name had a capital letter it wasn't in alphabetical order with the lowercase table names... [facepalm]