You will find that using a filter instead of a search is much faster. Also, you find it must faster to create a form-sun form for example:
MainForm = ID, Name Sub-Form = ID ( link), everything else. Now if you search in the MainForum for a name it will actually be faster - but you must disable the link to the sub forum while the search is going on, otherwise the update of the link is fired for each record as the search function actually moves the record pointer in the attached result set. A third route - a custom dialog to acquire the search information. Then apply this search to a clone of the result set, not the one attached to the UI components. I thin the first thing to look at is using the MainForm - SubForm trick. Remember the more rows you can get in memory the better so the smaller each row he better. That is the idea there...but do turn off those controllers during the search execution. If you want to look at doing this in detail then we can perhaps do so in the mailing list here, or using a wiki page or at the new OpenOffice.org forum - just as soon as those slackers setting it up get finished with the work.... An small example of this can be found in a couple of code snippet postings made at the OOoForum site, and at the MSA-Base FAQ wiki page. On 9/17/07, Cor Nouws <[EMAIL PROTECTED]> wrote: > > Hi *, > > I'm involved in a project where Base is used to import a csv file, that > is exported by a database. > > The csv file is stored on a network drive (NAS) and readonly available > for many users via a Base database stored on every PC (performance). > > The functionality in the datasource window is much appreciated, but > looking up a name in the 3000 + records (in just one table) takes quite > long. > > 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? > > > Thanks for the pointers, > Cor > > -- > > Cor Nouws > Arnhem - Netherlands > nl.OpenOffice.org - marketing contact > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
