On Wed, Jul 02, 2003 at 04:27:05PM -0500, Krister Lagerstrom wrote: > Are you sure about this? I found this in the source, but nothing about > column sizes:
I'm trying to remember where I saw that. Of course, that is bytes per row, but it's still a lot to work with if you have narrow columns. > > /* > ** The maximum number of bytes of data that can be put into a single > ** row of a single table. The upper bound on this limit is 16777215 > ** bytes (or 16MB-1). We have arbitrarily set the limit to just 1MB > ** here because the overflow page chain is inefficient for really big > ** records and we want to discourage people from thinking that > ** multi-megabyte records are OK. If your needs are different, you can > ** change this define and recompile to increase or decrease the record > ** size. > ** > ** The 16777198 is computed as follows: 238 bytes of payload on the > ** original pages plus 16448 overflow pages each holding 1020 bytes of > ** data. > */ > #define MAX_BYTES_PER_ROW 1048576 > > I still don't think we should put cached thumbnails in the DB, but there > might be other applications where it makes sense to store more data.... > > / Krister > > > > > > ------------------------------------------------------- > This SF.Net email sponsored by: Free pre-built ASP.NET sites including > Data Reports, E-commerce, Portals, and Forums are available now. > Download today and enter to win an XBOX or Visual Studio .NET. > http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 > _______________________________________________ > Freevo-devel mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/freevo-devel ------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100006ave/direct;at.asp_061203_01/01 _______________________________________________ Freevo-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/freevo-devel
