Skip to Content
0
Former Member
Dec 07, 2006 at 03:34 AM

Query memory consumption

142 Views

Hi,

Need some expert in SQL here. May i know how much memory (RAM) consumption for a simple query like 'SELECT SUM(Balance) FROM OCRD' cost.

What about query like

select (select sum(doctotal) from ordr) + (select sum(doctotal) from odln) + (select sum(doctotal) from oinv)

How much memory would it normally takes? The reason is that i have a query that is quite similar to this and it would be run quite often. So i wonder if it is feasible to use this type of queries withought making the server to a crawl.

Please note that the real query would include JOINS and such. Thanks

Any information is appreciated