V
Valeriy Bashkatov
Guest
Hello, When I loaded data from OpenEdge to MS SQL using Pro2SQL tools I found that the data in MS SQL take up more space (аpproximately > 3 - 4 times more) than in the Progress OpenEdge. Simple example: OpenEdge table: ADD TABLE "test1" AREA "Account Table" DUMP-NAME "test1" ADD FIELD "int1" OF "test1" AS integer FORMAT "->,>>>,>>9" INITIAL "0" POSITION 2 MAX-WIDTH 4 ORDER 10 ADD FIELD "dec1" OF "test1" AS decimal FORMAT "->>,>>9.99" INITIAL "0" POSITION 3 MAX-WIDTH 25 DECIMALS 10 ORDER 20 ADD FIELD "char1" OF "test1" AS character FORMAT "x(8)" INITIAL "" POSITION 4 MAX-WIDTH 150 ORDER 30 Create a four record with different sizes (lengths) for field char1: 1 22222 "12345678" 2 33333 "1234567891234567" 3 44444 "12345678901234567890123456789012345678901234567890123456789012345678901234567890" 5 21324 "123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890" MS SQL Table: CREATE TABLE test2 ( int1 integer null, dec1 decimal(25,10) null, char1 char(150) null, ) GO Create a similar four records: INSERT INTO [dbo].[test1] ([int1] ,[dec1] ,[char1]) VALUES (1 ,22222 ,12345678) GO INSERT INTO [dbo].[test1] ([int1] ,[dec1] ,[char1]) VALUES (2 ,33333 ,1234567891234567) GO INSERT INTO [dbo].[test1] ([int1] ,[dec1] ,[char1]) VALUES (2 ,44444 ,'12345678901234567890123456789012345678901234567890123456789012345678901234567890') GO INSERT INTO [dbo].[test1] ([int1] ,[dec1] ,[char1]) VALUES (4 ,21324 ,'123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890') GO in Progress OpenEdge size of these four records is 324.0B Table Records Size Min Max Mean Count Factor Factor PUB.test1 4 324.0B 32 144 81 4 1.0 1.0 but in the MS SQL is 8К: EXEC sp_spaceused N'test1' GO name rows reserved data index_size unused test1 4 16 KB 8 KB 8 KB 0 KB How to explain this? Regards, Valeriy
Continue reading...
Continue reading...