Make your own free website on Tripod.com

InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: resultsOnDisk - what's this used for?


John

Results sets normally exist only in memory. That's fine for small results
sets. However, unlike most databases, InstantDB does not just set up a
cursor when a query is evaluated - it actually creates the full results set
then and there. so a very large RS could end up taking up a lot of memory.
resultsOnDisk simply means that the results set table gets create on disk.
It is a temporary table and disappears as soon as it is no longer needed.

Regards

Peter Hearty
Instant Computer Solutions
-----Original Message-----
From: John H Thompson <thomps@WORLD.STD.COM>
To: instantdb@smartcard.co.uk <instantdb@smartcard.co.uk>
Date: 02 November 1999 21:59
Subject: resultsOnDisk - what's this used for?


>Peter...
>
>I've been looking at the information in the new version 3.10 prop.html
>and I find:
>
>      "resultsOnDisk ... Non-zero means that results sets get
>instantiated on disk."
>
>I'm not familiar with this.  Does this mean that if I do
>
>select * from <table_name> as <new_table_name> where ... etc.
>
>I will get <new_table_name> (the result set) placed in the directories
>where the properties file lives?
>
>Or is this too much to hope for?
>
>Regards, -JohnT.
>
>To unsubscribe from this list, please an send
>email to 'majordomo@smartcard.co.uk' with the text
>'unsubscribe instantdb' in the message body.

To unsubscribe from this list, please an send
email to 'majordomo@smartcard.co.uk' with the text
'unsubscribe instantdb' in the message body.