OK this is a little long so bear with me...

We had a copyright issue with the domain name on my original zencart site so I purchased hosing from the same company (myDomain.com). I then registered osdparts.com and paid my hosting company to make an EXACT copy of my database and files on the new hosting plan with the new domain. In theory it should work exactly the same as the old site right? It doesn't. It takes forever to load up any pages and we're losing business because of it. Note too Outlook email now takes twice as long to load on the new domain vs the original.

I opened a case with them Jan 9th and last Thursday (26th) they finally tell me the following...

"As per phpMyAdmin > Show MySQL runtime information, customer's database has several possible vectors for optimization. These inefficiencies may not have mattered on the previous hosting, but are coming into play now...

1. Handler_read_rnd 3,660.62 M The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly.
2. Handler_read_rnd_next 2,404.36 M The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have.
3. Created_tmp_disk_tables 106 M The number of temporary tables on disk created automatically by the server while executing statements. If Created_tmp_disk_tables is big, you may want to increase the tmp_table_size value to cause temporary tables to be memory-based instead of disk-based.
4. Select_full_join 2,259 k The number of joins that do not use indexes. If this value is not 0, you should carefully check the indexes of your tables.
5. Select_range_check 834 k The number of joins without keys that check for key usage after each row. (If this is not 0, you should carefully check the indexes of your tables.)
6. Sort_merge_passes 1,965 k The number of merge passes the sort algorithm has had to do. If this value is large, you should consider increasing the value of the sort_buffer_size system variable.
7. Opened_tables 119 M The number of tables that have been opened. If opened tables is big, your table cache value is probably too small.
8. Table_locks_waited 2,508 k The number of times that a table lock could not be acquired immediately and a wait was needed. If this is high, and you have performance problems, you should first optimize your queries, and then either split your table or tables or use replication."

I'm confused on how those supposed database issues slow the pages. I can understand it slowing searches but why would the database have anything to do with loading say the homepage? I'm also a bit confused why I would even have those problems when I use the zencart control panel and easypopulate to add products. Never received any errors from that either.

I'm getting nowhere with my hosting company and since I don't know much about programming, I have no idea how to begin to address what they suggested. Honestly am not sure that's even the issue. Anyone have suggestions on how I can get that thing moving faster or have a clue what's wrong? If there's anything I can have them do to get that thing loading quicker any help/suggestions are greatly appreciated!