Subject Re: Getting error Database Engine Error: Read failure:
From Milind Nighojkar <milinigh@yahoo.com>
Date Fri, 03 Sep 2021 22:53:18 -0400
Newsgroups dbase.getting-started

Hi Ken,
You are right I use Append.
Your pin pointed suggestion worked.
Extremly thankful to you.
As mentioned by you it increased the processing speed remarkably...

Regards

Milind Nighojkar


Ken Mayer, dBase, LLC Wrote:

> On 9/3/2021 10:42 AM, Milind Nighojkar wrote:
> > Scenerio:
> > Application work on data volume to the tune of 100000 records on temporary basis. I recreate work file by uploading it thru .csv file.
> > while doing this I get error Database Engine Error:  Read failure:
> >
> > The code used to work earlier.
> >
> > Any pointers?
> >
>
> What command are you using? If it is:
>
> APPEND FROM ...
>     Try adding the REINDEX option to the end of it. What *may* be
> happening is that for every record added, your index is being updated.
> If you use this REINDEX keyword in the command, dBASE will not reindex
> until done, then it will update your index tags. This will likely speed
> up the processing as well.
>
> 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