Hi.
I have a table of approx 10 columns and 12000 rows, continously
growing (wrt rows).
One of the columns is of type mediumtext, and contains html
documents of sizes up to one megabyte.
Most queries to this table does not include the document field,
but take still almost a minute. On a copy of the database, I
simply removed the document field, and similar queries reduced
processing time to just a tenth of a second.
So I thought, what if I created a new table, just containing
the primary key (the url) and the document? All queries to
the table not containing the document should be much faster then,
not?
But, will my _insertion_ performance and performance on queries
containing document field, be too much reduced? What are the
negative sides on splitting the table?
Hope somebody have the possiblity to answer me these questions
before I do something stupid...:)
Thanks,
--
Torkil Grindstein Mail: [EMAIL PROTECTED]
System Architect Web: http://www.fast.no
Fast Search & Transfer ASA Phone: +47 21 60 11 90
Grønnegata 80, Pb 571 Fax: +47 77 69 66 89
NO-9261 Tromsø, NORWAY Mob: +47 98 06 61 38
Try FAST Search: http://www.alltheweb.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
