| Subject | Re: SEARCHING VERY LARGE FILE |
| From | Ken Mayer, dBase, LLC <kmayer@dbasellc.com> |
| Date | Tue, 31 Aug 2021 05:54:48 -0700 |
| Newsgroups | dbase.getting-started |
On 8/30/2021 9:00 PM, AGOSTINHO wrote: > Dear group > I've a particular issue when searching this long file(more than 1 million records). > See form below, it searches perfect when typing anything(TEXT) that exists in the field. > The problem is when I type anything that don't exists than it hangs for a few second after I try to clear(BACKSPACE) the search-entryfield on the form. > Any idea how to avoid this behavior? Have you tried looking at SEEKER, which ships with dBASE, and works with local tables, or in the dUFLP, at SeekerSQL.cc class which is meant to work with SQL server databases? (There is also an ADO version) SEEKER, which you would want to use with dBASE tables, which yours seems to be requires an index that uses the UPPER() function on the field used, but it works really well and is fast. set procedure to :FormControls:Seeker.cc Then open the form in the designer and place this control on your form. It's that simple ... Ken -- *Ken Mayer*, dBase, LLC Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm dBASE Web Tutorial: http://www.goldenstag.net/dbase/WebTutorial/00_Menu.htm | |