dbForge Query Builder - System out of Memory

ROSinclair · Post by **ROSinclair** » Tue 25 May 2010 17:00

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

.jp · Post by **.jp** » Wed 26 May 2010 08:11

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.

niko09 · Post by **niko09** » Sat 17 Jul 2010 10:13

what? http://allsoft-best.ru/

.jp · Post by **.jp** » Mon 19 Jul 2010 09:31

niko09 wrote:what? http://allsoft-best.ru/

What you mean?