Subject Re: SEARCHING VERY LARGE FILE From Ken Mayer, dBase, LLC <kmayer@dbasellc.com> Date Tue, 31 Aug 2021 07:43:05 -0700 Newsgroups dbase.getting-started On 8/31/2021 6:50 AM, Mervyn Bick wrote: > On 2021/08/31 14:54, Ken Mayer, dBase, LLC wrote: > >> 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 ... > > Agostinho is using  LIKE in his select statement and '%'+this.value+'%' > as a parameter.  In other words he is looking for a match which may just > happen to be at the beginning of the field but could be anywhere in the > field's contents. > > A SEEKER uses an index and only moves the rowpointer to the first record > that begins with the search value.  In other words it won't do what > Agostinho needs. Well, there's no fast way to do what he wants, then ... 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