||Re: complex indexes vs index key fields
Mervyn Bick <email@example.com>
||Thu, 30 Jul 2020 10:39:47 +0200
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. :-)