The VC6 compiler is from 1998. The VC 7.1 or 8.0 compilers produce better compilations. I'm certain any Borland or GNU compiler of the past 3 years would also produce better assembly than VC6. And if somebody has their hands on a PathScale or Intel compiler, please post some benchmarks!
> I contacted Ralf who informed me that he knew of this speed > advantage and mentioned that he compiled his dll separately > using Borland. > An additional mystery is why using the 'optimize for speed' > compiler option actually slows down the result set processing. So that issue "optimize for speed" was with VC6 or with the Borland compiler? If it's for VC6, well, upgrade already. If it's for Borland's compiler, it is probably due to bugs in the memory management that were evident in BCB5/6. In that case use FastMM (or some equivalent) for the memory manager and see if that makes a difference. > I am using VC 6 C++ and SQLite 3.34. > My timing test uses the time reported my SQLite as reported > on the status bar, and for my code, I time only the sql_exec > stmt completion callbacks: > 'rc = sqlite3_exec(db, pSQL, callback1, 0, &zErrMsg);'. > My callback merely stuffs 5 columns into a char array with no > processing. > > Thanks for your help. > Michael >
