OpenEuphoria

MySql handler syntax

• Posted by George Walters <gwalters at sc.rr.com> Oct 25, 2004
• 653 views

Matt, I'm still having memory problem with a large inventory database
(22,000 records). I'm concerned because I do have some customers with
more than 80,000 records.I've increased the computer memory to 750MB but
although
it reads farther, it still crashed w/o enough memory. So there's a problem 
somewhere that's way over my head. Would it help if I emailed you the mysql
table to play with?

I'm also wondering if I can use mysql "HANDLER syntax" (page 521 in the mysql
manual). It seems it would be more appropriate to the type of interactive
file maintenance my software is using.  The reports should still use a cursor.
This would be for the file maitenance and data entry programs. It would solve
my "READPREVIOUS" problem which there's no realistic SQL syntax to handle it.

george