I am not good at DB theory, but in our practice
(SQL DB development form WEB since 97) splitting
a table to get recrods to be fixed length is always
beneficial when table is in haavy use. You can get fast
lookups and just a bit slower inserts, but since, inserts
are usually much rare compared to selects you won't
loos anything. Nowadays we also use caching tables,
which contain results from many other tables for
usual selects.
So, do the split. It is good for you:)
----- Original Message -----
From: "Torkil Grindstein" <[EMAIL PROTECTED]>
To: "mySQL Mailing List" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 12:56 PM
Subject: Large fields vs. performance
> 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
>
>
---------------------------------------------------------------------
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
