Page 1 of 1

dbForge Query Builder - System out of Memory

Posted: Tue 25 May 2010 17:00
by ROSinclair
I'm having difficulty with a very simple query involving two vertical databases. One database has around two hundred entries, the other around 400,000. I keep receiving the following error regarding system memory. This is a query I've run easily in other query tool environments, so I do not think it is due to a lack of physical system resources (8 gig of memory on system) . Please advise on what else could be causing this error.


1 Exception of type 'System.OutOfMemoryException' was thrown. Query1.sql 1 1

Posted: Wed 26 May 2010 08:11
by .jp
Try to use the "TOP(N)" clause or use the Paginal Mode by default (Tools -> Options -> Data Editor -> General -> Use paginal mode by default).
In the next versions we are planing to decide whether to release the disk cache feature and then all the OutOfMemory exceptions will disappear.

Posted: Sat 17 Jul 2010 10:13
by niko09

Posted: Mon 19 Jul 2010 09:31
by .jp
niko09 wrote:what? http://allsoft-best.ru/
What you mean?