Hi Cor, > Are there alternatives, way's to improve this? > F.i a way to index this table? And / or doing a search on every > keystroke in a column?
If you use the HSQL engine to link to those .csv files (see the "Text Tables" documentation at hsqldb.org how to set up this, unfortunately this needs to be done manually via the Tools/SQL command currently), then you can also add indexes to the tables, which should increase lookup times. 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]
