Subject Re: complex indexes vs index key fields
From Mervyn Bick <invalid@invalid.invalid>
Date Thu, 30 Jul 2020 10:39:47 +0200
Newsgroups dbase.getting-started

On 2020-07-30 08:54, Akshat Kapoor wrote:

> Just a word of caution,
> MySQL can accept 1000 rows in a single query,
> But the query s being built up as a dbase memory variable and it will
> have its own limits.
>
> For rows of small size it will not matter, But if rows get large i.e. eg
> 4k for each row then ?

4k was the limit for a record in a level 4 .dbf file.  The limit is now
32767 bytes.  That's a seriously BIG record.  :-)

The only limit on a dBASE memory variable is available memory. With
nothing else going on in dBASE, memory(9) returns 2097151 on my computer.

I've just loaded a 1.72MB (1831711 bytes) text file into a memory
variable as a test using a file object's read() method.

   cRead = f.read(2000000)

It took 0.02 seconds.

The longest INSERT statement to insert 1000 rows using Gaetano's test
data was just over 73000 bytes.  Neither dBASE nor MySQL will even raise
a sweat. :-)

Mervyn.