Hi Fernand, >>> I think however - and I think that Frank's response answers it - that >>> the question is one of 'best practices'. >>> >> Actually, I am not completely sure what the original question was :) >> > I want to understand how the Base application is building the SQL > statements based on the command, filter and sort properties an finaly > how "cost" effective is this statement on the the server side.
Letting Base assemble the final statement form its parts - the basic query, the filter, the sort order, the having clause, the group-by clause - is certainly more expensive than you manually creating the string, but I'd say to a little amount only. What happens is that Base asks for some meta data (the quoting character, probably), and then just concatenates some strings. > Behind > this question is also a concern, when developing a frontend I must > produce code who will work for more than one Driver. When using a local > network then i sould use the Native MySql-connector when going over the > web then a ODBC connector comes in place. Native MYSQL statements will > work for both drivers , will statements build by the Base application do > alsoo ? =) If the drivers work properly, then yes :) Finally, that's one reason of existence for the Base API: abstract from the underlying database/driver, and allow client code to be generic. Of course, from a certain point on, this is illusionary, as the abstraction level of the SDB/C/X API does not (and cannot) capture /everything/ which would needed ... Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
