MemoryError inserting rows in db

[totetote]

Hello. I made an script to insert rows into my db. All seems to work fine when small amount of rows are inserted. But, when I try to insert lot of them I get a "MemoryError" and all progress is avoided.

I would like to know why this MemoryError happens. I don´t know if its because the db is too big (I doubt, it would be about 700-800Kb), the script is too long (I get the error when I try to insert more than 4.000 lines more or less), or whatever. My code is very simple, something like that.

Any help or suggestion is welcome.

Thanks

import e32db
db_name = u"C:\\Python\\test.db"
try:
    db = e32db.Dbms()
    db.open(db_name)
    db.execute(u"DELETE FROM test")
except:
    db.create(db_name)
    db.open(db_name)
    db.execute(u"CREATE TABLE test (aaa VARCHAR, bbb VARCHAR, ccc INTEGER)")
db.execute("INSERT INTO test (aaa, bbb, ccc) VALUES ('%s','%s', %d)"%(u"ola", u"hola", 1))
##MORE AND MORE INSERTS
db.compact()
db.close() 

[croozeus]

Any help or suggestion is welcome.

Which device do you use to run this script?

Best Regards,
Croozeus

[totetote]

Which device do you use to run this script?

Best Regards,
Croozeus

I´m using Symbian OS Emulator.

I made some new tests, and have a little more info.

I have default config on emulator excepting Memory Capacity at 128MB (also tried default, 64MB, etc) I monitored mem usage while running the script and nothing strange happened. Mem Usage increases from 8.5MB idle to 25MB while script runs. Neither mem usage peak when MemoryError happens.

It also creates a python_error.log file with following message:
"no mem for next token".

Complete error given in Python is this:

Traceback (most recent call last):
File "c:\private\2000b1a5\default.py", line 81, in menu_action f()
 File "c:\private\2000b1a5\default.py", line 6, in query_and_exec
  execfile(script_list[index][1].encode('utf-8'), script_namespace.namespace)
MemoryError 

UPDATE:

I tried the same script in a nokia e65, and got the same MemoryError (faster this time)
I tried a "lighter" script (that works OK in the emulator) with about 4000 rows, and phone gets crazy. First gets frozen, then it seems to autoreboot, and it creates the database, but only with the first 400-500 rows.

Any info about physical limits in DB is welcome too.

Thx again for helping

[totetote]

Noone had or solved any problem during massive operations against database?