The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
How many fields too many for one table?
Posted: 09 May 07 8:28 AM
|
fiogf49gjkf0d SLX v7 SQL 2005 - How many fields are too many for one slx table? I believe the SQL server limit is 1,024.
Will I have any problems with Syncing or otherwise if I put around 100 fields in one table?
Thanks |
|
|
| |
|
Re: How many fields too many for one table?
Posted: 09 May 07 2:53 PM
|
fiogf49gjkf0d I believe the relevant limits are the 8k bytes per record. You can define a record in excess of this and it will work fine until the data exceeds the 8k limit and fails. Likewise a recordset I think is still limited to 250 columns and this has a direct impact on several layers of the system. |
|
|
| |
|
Re: How many fields too many for one table?
Posted: 09 May 07 9:54 PM
|
fiogf49gjkf0d -Datalength() in ms sql will give you the data length as apposed to the defined field length. I use it a lot when trying to move data or reduce the field lengths used in indexes.
-I'm not in a place to check but the DB Manager of slx used to tell you the record size at the top (or bottom) of the window.
Note Blobs and Memos hold a fixed byte count (16 maybe) of the 8K max.
|
|
|
|