[EMAIL PROTECTED] wrote:


I think that was fixed by check-in [3868].

Richard,

It seems you were right again. :-)

I'm not sure what caused my build to have a problem, but after building and running the test suite on Linux with no problems, I rebooted into Windows.

I did a make clean and make to rebuilt and notices that the version number 3.3.16 was being copied into the sqlite3.h file. The version number is hard coded into the Makefile by configure, so I completely cleared my build directory, re ran configure, and rebuilt the library and reran the test. Everything except the alter-7.1 test now passes. I'm sorry for wasting your time.

I did notice something strange that make be related to the recent discussion about SQLite's speed on various flavors of Windows.

When I run the test suite in Windows XP (Pro SP2 with all updates) it takes about 30 min to complete with the hard drive light on for almost the entire test. Task Manager shows the testfixture application using between 0 and 10% of the CPU and usually less than 5%. This is about what I would expect for an I/O bound program like this.

   Thread-specific data deallocated properly
   1 errors out of 26993 tests
   Failures on these tests: alter-7.1
   make: *** [test] Error 1

   real    31m30.063s
   user    0m0.092s
   sys     0m0.015s

When I run the test suite under Linux (Ubuntu 7.04 Feisty Fawn) using a reiserfs file system it only takes about 2 min to complete and the hard drive light is mostly off, blinking on only occasionally. Top show the testfixture running at between 60% to 90% of the CPU with most time spent at about 75% with another process running fairly constantly at about 20% CPU. This looks very much like a CPU bound program.

   Thread-specific data deallocated properly
   0 errors out of 28824 tests
   Failures on these tests:

   real    1m42.484s
   user    0m43.899s
   sys     0m17.633s

Do you, or anyone else, know why the linux version would not be committing its changes to disk?

This was the same program executing on the same CPU. The two OS's are on different hard drives. Windows is on a Maxtor 6E040L0, while Linux is on a Segate ST3802110A. These drives are fairly evenly matched

drive        6E040L0      ST3802110A
size          40 GB         80 GB
speed         7200 rpm      7200 rpm
access        10 ms         11 ms
cache         2 MB          2 MB
interface     ATA133        ATA100

Both drives are on the same IDE interface on the CPU.

I am going to repeat the test using the same FAT32 partition from both Win XP and Linux to eliminate this difference.

How long does the test suite (quick test) take to execute on your linux system?

Dennis Cote

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to