Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
November 4, 2008, 9:07 am
rate this thread
it shows that one table in the database (mysql) has bad overhead, so I keep
having to optimize the table.
What causes this to happen so I can get rid of the problem or is it normal?
all the table actually hold is text.
this is the table structure:-
txt_id mediumint(8) UNSIGNED NOT NULL auto_increment,
txt_mod_id mediumint(8) UNSIGNED NOT NULL,
PRIMARY KEY (txt_id)
"There are two ways of constructing a software design: One way is to
make it so simple that there are obviously no deficiencies, and the
other way is to make it so complicated that there are no obvious
deficiencies. The first method is far more difficult."
-- C.A.R. Hoare
November 4, 2008, 10:28 am
The table design itself doesn't say much. Just have a look at your code
and look for common errors: fetching unnecessary data, redundant
queries, filtering by non-indexed columns... Also, MySQL itself offers
several tools to optimize queries: slow queries log, explain plans...
But that's beyond the scope of this group ;-)
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://bits.demogracia.com
-- Mi web de humor al baño María: http://www.demogracia.com
- Captain Paralytic
November 4, 2008, 12:31 pm
- » Ordering a list of items. I am nearly there but there's something worth a second pair of ...
- — Next thread in » PHP Scripting Forum