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.
Instant Computer Solutions
From: John H Thompson <thomps@WORLD.STD.COM>
To: email@example.com <firstname.lastname@example.org>
Date: 02 November 1999 21:59
Subject: resultsOnDisk - what's this used for?
>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?
>To unsubscribe from this list, please an send
>email to 'email@example.com' with the text
>'unsubscribe instantdb' in the message body.
To unsubscribe from this list, please an send
email to 'firstname.lastname@example.org' with the text
'unsubscribe instantdb' in the message body.