If you are using the verson of Sqlite in one big file you are expecting 
a lot from the optimizer.  I would never compile Sqlite that way, 
instead do it the normal way and link the optimized. code.  Also make 
sure you remove the -g option which interferes with some AIX linking.

My experience with IBM's Xlc is that it has a very aggressive optimizer 
and will produce optimized code of high quality, running on one of my 
tests 40% better than gcc code.  I would not compile large files with it.

Ribeiro, Glauber wrote:
> Unfortunately gcc is not an option right now.
> I wouldn't be very surprised if it turned out to be that the very large
> source file is overwhelming IBM's optimizer. So far the non-optimized
> compiles of sqlite3 are working fine. 
> 
> -----Original Message-----
> From: John Stanton [mailto:[EMAIL PROTECTED] 
> Sent: Monday, September 22, 2008 11:34 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Core dumps on AIX with optimization
> 
> We use gcc.
> 
> Ribeiro, Glauber wrote:
>> This issue continues with version 3.6.2
>>
>> g 
>>
>> -----Original Message-----
>> From: Ribeiro, Glauber 
>> Sent: Friday, September 19, 2008 11:55 AM
>> To: General Discussion of SQLite Database
>> Subject: [sqlite] Core dumps on AIX with optimization
>>
>> Just wondering, are there other AIX Sqlite users out there, and what
>> have you done in order to get a successful compile?
>>
>> I found out that on our AIX 5.2, with IBM's Visual Age C v9.0, the
>> command line utility sqlite2 dumps core when running SQL that contains
>> an aggregation function, if it was compiled with any level of
>> optimization. It seems to work fine if C optimization is turned off.
>>
>> I reported this at http://www.sqlite.org/cvstrac/tktview?tn=3344,2
>> (ticket 3344), and at least one more person reported seeing the same
>> problem.
>>
>> I'm not worried about the lack of optimization, just thinking that
> this
>> may be caused by an underlying problem in the C code.
>>
>> Thanks,
>>
>> glauber
>>
>> _______________________________________________
>> sqlite-users mailing list
>> [email protected]
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to