Hi Fernand, > Can someone confirm the following "performance" options: > When using the API and basic to load the data in a form based on a SQL > command, I suppose that it sould be better to include the filter options > directly in the the SQL statement and not using the filter and sort > properties off the form. I suppose that OO after changing the sort or > filter property simply rebuild the SQL statement and send a new request > to the server ?
A new statement is built and sent as soon as you call the form's load/reload (resp. execute) method. So, it doesn't really matter whether you set the Filter/Sort at the respective properties, or directly in the SQL command: The subsequent re/load call will compose the statement (which you would need to do, too) and send it to the server (which you would need to do, too). 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]
