Freezing
| User, date | Message |
|---|---|
|
Written by mormaii
11 months 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
11 months ago 3952 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
11 months 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
11 months ago 3952 posts since Fri, 07 Apr 06 |
Great. Yes, remote hosts are often slow. |
|
Please login to leave a reply, or register at first. |