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
frank.schoenheit@... -
- Sun Microsystems
http://www.sun.com/staroffice -
- OpenOffice.org Base
http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail:
users-unsubscribe@...
For additional commands, e-mail:
users-help@...
