hi, i'm trying to choose a db, and looking at mysql.
here's the problem.
we're looking at storing large blob type objects - up
to 30,000 char's per field, and possibly a table of
1000 records by 300 fields/record.
can i put that all in one table? I have mac osx, so
i'm not worried about the filesize constraints.
my other question is, if i reverse the layout, i.e.
store the data vertically with one char/field (i know,
tons of wasted overhead) with 30,000 records, can my
sql realistically and efficiently deal with a switch
of how the data is stored(i.e. records being in
columns instead of rows) and can it effeciently deal
with 1000 tables
__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
