[maclun123]

Hi,

I encountered problem with memory after sending 2039 queries to SQL DB.
It always occurs after 2039. I would like to increase somehow memory in order to avoid the problem.
I read some posts about feature in ensymble - don't want to use as i am not working on SIS yet.
I saw also MISO package, but I had no success in using it for this purpose.
Can anyone give me example how to increase memory with MISO? Which function I should use?

EDIT: Error I am getting on "self.dbv.prepare(self.db, unicode(sql))" line.

added code which I am using

class Db:
	def __init__(self, db_path):
		self.dbpath = db_path
		
		self.db = e32db.Dbms()
		self.dbv = e32db.Db_view()
		self.reset_counters()
		self.db_opened = False

	def query(self, sql):
		self.reset_counters()
		if sql.lower().startswith('select'):
			self.dbv.prepare(self.db, unicode(sql))
			self.dbv.first_line()
			self.num_rows = self.dbv.count_line()
		else:
			self.db.execute(unicode(sql))

Thanks,
mac

[Rafael T.]

Well, the error is occuring probably because the file is too large, exceeding the heap size, which is generally 1 MB.



BR,

Rafael.

[maclun123]

My file has size around 950 kB, and number is 2039. On the file where size is over 2 Mb is probably around 1400 (cant check exactly).
I have just tested with file with 8 EMPTY tables (file less than 4 kB) and the number is 5104. For 8 tables with ONE entry - around 3500.

It seems that problem lies somewhere else. Any ideas?

And second question is still unanswered... how to change heap size with miso?

mac

[Rafael T.]

Originally Posted by maclun123

And second question is still unanswered... how to change heap size with miso?

As long as I know, the only way to change heap size is when you pack your application into a .sis using the heapsize option from Ensymble.

[maclun123]

I have tried to do it with ensymble, and my problem is still there;/
As I don't see console I don't know what is exact message, but application behaves as it used to from under Python Script Shell.

I have set in ensymble heapsize to "--heapsize=4k,4M". but the number of SELECTS didn't increase;/

I don't if I am doing something wrong...
Please advice, if you have any ideas.

Exact ensymble command:

ensymble.py py2sis --heapsize=4k,4M --uid=0x000b1a5 --appname=PhotoGallery --caps=LocalServices+Location+NetworkServices+PowerMgmt+ProtServ+ReadUserData+SurroundingsDD+SWEvent+UserEnvironment+WriteUserData+ReadDeviceData+TrustedUI+WriteDeviceData --version=1.0.2 --lang=EN --verbose PhotoGallery.py

mac