Hi,
thank you very much for SQLObject. I do really enjoy using it.
I use SQLObject 0.7 and came across the following problem: When running
the attached minimal example (on Windows XP), one can see the
handle-count and memory-used in Windows Task-Manager go up. For every
item inserted into the table 1 windows-handle and 1 kB memory is used.
Even worse, the same amount of resources is also used, when pulling
items from a table. I know SQLObject does cache the items, but I wonder
if the windows handle really has to be kept. Further, if I have a long
running application which uses a moderately big database containing
about 500.000 entries, sooner or later the application will take >500 MB
in memory :/
Kind regards,
Markus
from sqlobject import *
__connection__ = 'sqlite:/:memory:'
class Item( SQLObject ):
title = StringCol()
Item.createTable()
for i in range( 100000 ):
item = Item( title = str( i ) )
import time
time.sleep( 10 )
