Hello,

I use SQL Anywhere 5.5.04 on Windows and SQL Anywhere 7.0.2
on Linux.
I exclude many rows of a table and the database grow up.
OK, caused by rollback and checkpoint logs.

But, the database grow up more on Linux than Windows.

Obviously my tests starts with the same database.

Why this different behavior between Linux and Windows?

Thanks in advance,
Renato Cramer.

For a start, the database file format is different between the two
releases, so that may account for some of the difference. Is the database
page size identical between the two databases?

What *is* the difference, anyway?

Glenn

Renato Cramer wrote in news:444e6f87.d0b.1681692777 (AT) sybase (DOT) com:



--
Glenn Paulley
Research and Development Manager, Query Processing
iAnywhere Solutions Engineering

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Yes, the database page size is identical because is the same
database (files .db and .log) to both tests. In others
words, I have a database, I get this database, put on linux
and make the test. After, I get the same database, put on
Windows and make exactly the same test. This database was
created with SQL Anywhere 5.5.

The database has 200 MB. After the test on Linux, 250 MB.
After the test on Windows, 220 MB.
Why?

Thanks in advance.
Renato Cramer.

What sort of file system are you using on the two platforms?
Perhaps the differing characteristics of the underlying file system might
explain the delta in the space consumed.

Kerry Liles
iAnywhere



<Renato Cramer> wrote

Version 5.5 is different that version 7.0, so we still don't know whether
the change in size is the result of the different OS (which I doubt) or the
different software (which is much more likely). Is it possible for you to
perform the following test :

1) Install ASA v702 on Windows.
2) Start with your v5.5 database that is 200 MB in size.
3) Run your test on Linux using ASA v702.
4) Run your test on Windows using ASA v702.
5) Compare the size of the files database files after each test.

Aside : Both v702 and v55 have been end-of-lifed for some time now
(http://www.ianywhere.com/developer/eol/index.html). We're not going to be
making any changes to either branch regardless of what the results of this
test are. A better test to see if the OS is really the cause of the
increased growth would be :

1) Download and install the v902 Developer Editions for both Windows and
Linux (http://www.ianywhere.com/downloads/index.html)
2) Start with your v5.5 database that is 200 MB in size.
3) Do an unload and reload of the database to bring the database to the v902
file format.
4) Run your test on Linux using ASA v902.
5) Run your test on Windows using ASA v902.
6) Compare the size of the files database files after each test.

If you see a significant difference after this second test, then it's
something we'd like to look at.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


<Renato Cramer> wrote