distal-attribute
distal-attribute
distal-attribute
distal-attribute

Freezing

User, date Message
Written by mormaii
2 years ago
Category: General
2 posts since Wed, 13 Jun 12
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!
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
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.
Written by mormaii
2 years ago
2 posts since Wed, 13 Jun 12
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.
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
Great. Yes, remote hosts are often slow.
 

Please login to leave a reply, or register at first.