binary data expertise required in 12.5.2 version
Posted on 2005-05-12
We have a database in Sybase version 11.0.2 ,it has only one database which has only one table.
This table has 4 columns of the following types:
It occupied 500 Megs in version 11.0.2 with 6000 rows.
Now we migrated Sybase to 12.5.2, now the same application runs against this database and the application failed.
It required space ,in a matter os 2 hours ,we added 15 gigs of space.
If I select the number if rows ,it has gone to 10,000 only.
But the space has increased many folds.
Can you explian ,why and how I can bring it back to 500 or even 100 megs rather than 15 gigs
How can I find out how much space each row is occupying,and what is the largest row in there.
thank you for your answer.