TOPIC: Displaying records in the backend just not happening

Our database is showing 6k user and 168K user_field_values

Which is probably while it now taking forever for the backend to display anything or something never come back

My take is if the page got load without records and the user filtered on the event to display records.

Or some other simple initial display as I think the code is trying to initially do something with all records and it just not workable on very large databases of registrations.

Some more information from the hosting guys while the performance on MySQL is slow.

appear to be queries large enough to lock tables and cause MySQL to start dumping data to disk.
| 5934319 | campsome_joom3 | localhost | campsome_joom3 | Query | 8751 | Copying to tmp table | Select SQL_CALC_FOUND_ROWS u.*, f.* ,f.status fee_status , u.status user_status , e.title , d.code , |
| 5934450 | campsome_joom3 | localhost | campsome_joom3 | Query | 2976 | Waiting for table level lock | select * from kqtpe_dtregister_group_event where 1=1 order by dtstart desc |

Can some of those 6k records not be archived?? That is the point of archiving... so you don't have to deal with such a massive load of data. When you archive an event, the records also are archived. Still accessible, but they are moved to different tables to take some weight off of the main tables.