Freezing

Hello, whenever i try to browse one of my tables on my remote host the program freezes and i have to restart it. Some tables have over 50.000 column but i limit the display amount to 500 (reduced it from 1000 to see if it changes anything) But even when i try to browse to a table with 50 columns the program freezes. What can i do to fix it?

By the way: It's not my computer since i have an I7 running at 3GHZ and 16GB of RAM with an SSD. Any help will be appreciated!

You have 50 thousand columns in one table? You should think about a database redesign, man. That's totally crappy, unless you have not mixed up columns and rows... Please post a CREATE TABLE query here from a table which freezes.

Sorry i mixed up columns and rows. There's tables with around 50 thousand rows. I think it may be the hosting because now it seems to be working better.

Great. Yes, remote hosts are often slow.