On Thu, 14 May 2009 15:18 +0300, "Domas Mituzas" <[email protected]> wrote: > Hello, > > > Are there any disadvantages that would result from doing work on > > using a > > database abstraction layer such as Adodb? Or advantages that are > > gained > > from the current methods of accessing databases. > > our layer is abstracting queries, not only database API. there're some > differences between two approaches. > > Cheers, > Domas > The approach of abstracting queries does appear to be a good option, rather than just abstracting the database API, as then queries could possibly be done using SQL statements that use particular features or syntax specific to the database server.
>From looking further into ADODB, it appears that the performance hit from using it could be significant for projects like Wikipedia (14% or so from the statistics on the ADODB site). So abstracting the database API using something like ADODB may not be a good option after all, to get it to work better with other databases than MySQL. There does not seem to be any projects with a similiar size to the ones that use MediaWiki , which use ADODB and support a range of databases. Regards, Karun > _______________________________________________ > Wikitech-l mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikitech-l _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
