Advantage Database Server: in-memory queries.

Posted by ie on Stack Overflow See other posts from Stack Overflow or by ie
Published on 2010-04-29T09:43:31Z Indexed on 2010/04/29 12:27 UTC
Read the original article Hit count: 287

Filed under:

advantage-database-server

|

memory-management

As far as I know, ADS v.10 tries to keep result of query in memory until it is a quite huge. The same should be true for the __output table and for temporary tables. When the result becoming large, swapping stated.

The question is what memory limit is set for a query, a worker, whatever? Could this limit be configured?

Thanks.

© Stack Overflow or respective owner

Related posts about advantage-database-server

Transferring data from Advantage Database Server to SQL Server

as seen on Stack Overflow - Search for 'Stack Overflow'
My client is using Advantage Database Server and wants to move to SQL Server but obviously wants to move all his clients data as part of the upgrade over to SQL Server. I've thought about writing an app to do the transfer but thinking it might be more trouble than its worth. What would you recommend… >>> More
Using the .NET Entity Framework with the Advantage Database Server

as seen on Internet.com - Search for 'Internet.com'
Learn how to use Microsoft's .NET Entity Framework to connect to, consume and update an Advantage database. >>> More
Using the .NET Entity Framework with the Advantage Database Server

as seen on Internet.com - Search for 'Internet.com'
Learn how to use Microsoft's .NET Entity Framework to connect to, consume and update an Advantage database. >>> More
Using the .NET Entity Framework with the Advantage Database Server

as seen on Internet.com - Search for 'Internet.com'
Learn how to use Microsoft's .NET Entity Framework to connect to, consume and update an Advantage database. >>> More
Using SQL Server Analysis Services with Sybase Advantage Database Server

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to use SQL Server 2008 Analysis Services with data stored in Sybase Advantage Database Server? Either directly, or via SQL Server Integration Services. >>> More

Related posts about memory-management

Memory management in objective-c

as seen on Stack Overflow - Search for 'Stack Overflow'
I have this code in one of my classes: - (void) processArray { NSMutableArray* array = [self getArray]; . . . [array release]; array = nil; } - (NSMutableArray*) getArray { //NO 1: NSMutableArray* array = [[NSMutableArray alloc]init]; //NO 2: NSMutableArray* array = [NSMutableArray… >>> More
android memory management outside heap

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I am working on an application for android and we since we have lots of graphics, we use a lot of memory. I monitor the memory heap size and its about 3-4 Mb , and peeks of 5Mb when I do something that requires more memory (and then goes back to 3). This is not a big deal, but some other stuff… >>> More
Javascript new keyword and memory management

as seen on Stack Overflow - Search for 'Stack Overflow'
Coming from C++ it is hard grained into my mind that everytime I call new I call delete. In javascript I find myself calling new occasionally in my code but (hoping) the garbage collection functionality in the browser will take care of the mess for me. I don't like this - is there a 'delete' method… >>> More
Memory management / ownership question?

as seen on Stack Overflow - Search for 'Stack Overflow'
Do I have this right ... // Reactor.h @property(nonatomic, retain) NSMutableArray *reactorCore; // Reactor.m [self setReactorCore:[NSKeyedUnarchiver unarchiveObjectWithFile:[self dataFilePath]]]; ... -(void)dealloc { [reactorCore release]; [super dealloc]; } I am pretty sure I am doing… >>> More
Memory management in ObjC/iPhone

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have question in memory management (objective C). There are two ideal scenario. ============================= scenario 1 ======================================== (void) funcA { MyObj *c = [otherObj getMyObject]; [c release]; } -(MyObj *) getMyObject //(this method is available in… >>> More