> >>>We have a table that grow by 200MB each day. > >>>Should we put data in different tables or is one big table just as fast? > > > > The table contains data from RSS and Atom feeds. > > Most users only need to see the newest items. > > A select could look like this: "SELECT title, desc FROM items WHERE > > feedid = 25 ORDER BY id DESC LIMIT 10" > > I would, however, be seriously concerned about diskspace if a table is adding > 200 MB a day with no archiving/compression/purges.
What if we use COMPRESS() for the text in old rows? Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
