Hi,
As far as table size considerations and storage efficiency I have the following
question:
I would like to store articles in mysql table.
I will display only the title on one page.
only title and first two sentences in two more pages.
the whole article i will display in one page only if the user cliks to see
all....
based on this:
1) apart from title and first two sentences, should i store the rest of the
whole article (which is a lot more text) in the same table, or in another table
or in another file or how? of course i prefer to store the whole article in one
row of one table. but i am wondering if that way is efficient?
2) when storing sentences or paragraphs of the article, should i just assign
TEXT variable to those columns? it looks like the easiest way, but as far as
table size, is it efficient? for example limiting a columnsize with varchar()
or something like that is it more efficient? or is there a trim function or
something like that to help storing efficiency?
Thanks
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
[Non-text portions of this message have been removed]
