||Re: Getting error Database Engine Error: Read failure:
Milind Nighojkar <email@example.com>
||Fri, 03 Sep 2021 22:53:18 -0400
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...
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 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