RE: Some table questions
"Dittmar, Daniel" <[email protected]> Tue, 18 Mar 2003 14:12:59 +0100
| Newsgroups | gmane.comp.db.sapdb.sources |
|---|---|
| Message-ID | <B9A2DDA03044D311BBD40008C75D6968147D85AA@dewdfx24> |
> What [source location specifies that] > the table row has a limit of 8088 Bytes ? This is due to the page size and that rows currently cannot span across pages. That this becomes a problem has less to do with the actual size of 8088 bytes and much with the way that rows are constructed in memory. These in-memory-rows generally use the defined width of columns (21 bytes for a VARCHAR (20)), not the size of the actual data. There is some work being done on removing both limits - storing only the actual data in fields (which also fixes the problem with "hello " being stored the same as "hello") - spanning rows across pages These changes are not trivial, so it will take a while before they are actually available. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [email protected] http://www.sapdb.org/