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

Freezing

mormaii posted 3 years ago in General
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!
ansgar posted 3 years ago
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.
mormaii posted 3 years ago
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.
ansgar posted 3 years ago
Great. Yes, remote hosts are often slow.

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