Not enough memory/Virtual memory error from large query 
Author Message
 Not enough memory/Virtual memory error from large query

I'm getting a "not enought memory" error while executing a large query
going from Paradox 7/8 to Oracle.  The result set is over 200MB in size,
but the hard drive has more than enough space (1 Gig free), I have 32 MB of
memory on board, and the Windows NT virtual memory file is set to maximum
of 150 MB.

Can anyone tell me what's wrong?  Is this something I need to set in the
Windows NT control panel, or in Paradox?



Sun, 30 Jul 2000 03:00:00 GMT
 Not enough memory/Virtual memory error from large query


: I'm getting a "not enought memory" error while executing a large query
: going from Paradox 7/8 to Oracle.  The result set is over 200MB in size,
: but the hard drive has more than enough space (1 Gig free), I have 32 MB of
: memory on board, and the Windows NT virtual memory file is set to maximum
: of 150 MB.

Paradox will create intermediate temporary tables while executing
your query, and they can be huge.  Try executing a series of
queries, where the first one limits the size of the data to
be processed in the subsequent queries.
--
============================================================

============================================================



Mon, 31 Jul 2000 03:00:00 GMT
 Not enough memory/Virtual memory error from large query

The problem is, we need to be able to execute queries of this size.  It
hardly seems excessive to want to be able to do a query which produces
150-200MB worth of data, is it?
Is there no way to tweak NT or Paradox 7 so that it can execute a proper
query without work-arounds?

Quote:
> Paradox will create intermediate temporary tables while executing
> your query, and they can be huge.  Try executing a series of
> queries, where the first one limits the size of the data to
> be processed in the subsequent queries.
> --
> ============================================================

> ============================================================



Mon, 31 Jul 2000 03:00:00 GMT
 Not enough memory/Virtual memory error from large query

Which version of the BDE do you have?  It may help if you get the latest
version, which is 4.51 from Borland's web site (www.borland.com)

Alan


Quote:

>The problem is, we need to be able to execute queries of this size.  It
>hardly seems excessive to want to be able to do a query which produces
>150-200MB worth of data, is it?
>Is there no way to tweak NT or Paradox 7 so that it can execute a proper
>query without work-arounds?

>> Paradox will create intermediate temporary tables while executing
>> your query, and they can be huge.  Try executing a series of
>> queries, where the first one limits the size of the data to
>> be processed in the subsequent queries.
>> --
>> ============================================================

>> ============================================================



Wed, 02 Aug 2000 03:00:00 GMT
 Not enough memory/Virtual memory error from large query


Quote:

> The problem is, we need to be able to execute queries of this size.  It
> hardly seems excessive to want to be able to do a query which produces
> 150-200MB worth of data, is it?
> Is there no way to tweak NT or Paradox 7 so that it can execute a proper
> query without work-arounds?

> > Paradox will create intermediate temporary tables while executing
> > your query, and they can be huge.  Try executing a series of
> > queries, where the first one limits the size of the data to
> > be processed in the subsequent queries.
> > --
> > ============================================================

> > ============================================================

The temporary tables are stored in the private directory. Make sure you have sufficient
space on that drive as well your data drive (if they are different)
--

RHM Consulting



Mon, 07 Aug 2000 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Any Experienced ..FRM-40901 Error (not enough memory to remember all or part of this query)

2. HELP: Not enough memory to increase memory!

3. Not enough memory to complete query

4. Error Message "Not Enough Memory"

5. Not enough memory error

6. Error message "Not Enough Memory"

7. Not enough memory error.

8. ERROR: 17803 - not enough memory

9. "Not enough memory" error during compile

10. Not enough Memory BDE Error

11. Error msg: Not enough memory...

12. Errors on linux, not enough memory?


 
Powered by phpBB® Forum Software