GDA interim benchmarking synopsis

[Derek Atkins]

Hi,

Mark Johnson <mrj001 at shaw.ca> writes:

[snip]
> SQLite and MySql are completely opposite as to which queries perform 
> well and poorly.  That's why I want to see if I can adjust the queries 
> and indices to do better.

I'm really beginning to wonder if we need to write special SQL
based on the database we're using in order to tune the performance
because of issues like this?  Yes, I know that that sort of defeats
the purpose of using a library like GDA, but if GDA can't form
an optimal query then it might behoove us to do the right thing
rather than hope they do.

> I may take a break from this to see about patching the PostgreSQL 
> provider to test it, too.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available