Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

UncommonSQL and immediate retrieval

1 view
Skip to first unread message

Wojciech Sobczuk

unread,
Jul 25, 2002, 5:05:08 AM7/25/02
to
Hello,

Has anyone worked with UncommonSQL, and made it immediately retrieve
objects from join slots? If so, I'd like to see some examples of that
done. I can't get it to work with :retrieval :immediate in the :db-info
slot.

Sincerely,
Wojciech Sobczuk

Wojciech Sobczuk

unread,
Jul 25, 2002, 5:13:10 AM7/25/02
to
Ok, take that back. It's on the TODO list. I'm screwed.

Wojtek

Craig Brozefsky

unread,
Jul 25, 2002, 3:32:34 PM7/25/02
to
Wojciech Sobczuk <woj...@nemo.pl> writes:

> Ok, take that back. It's on the TODO list. I'm screwed.

In all honesty, while it may be in the TODO list, I doubt it will
get done unless you or someone else does it.

--
Craig Brozefsky <cr...@onshored.com> Senior Programmer
onShore Development http://www.onshore-devel.com
Free Common Lisp Software http://alpha.onshored.com/lisp-software

Dave Bakhash

unread,
Jul 25, 2002, 6:18:12 PM7/25/02
to
Craig Brozefsky <cr...@red-bean.com> writes:

> Wojciech Sobczuk <woj...@nemo.pl> writes:
>
> > Ok, take that back. It's on the TODO list. I'm screwed.
>
> In all honesty, while it may be in the TODO list, I doubt it will
> get done unless you or someone else does it.

What I think is that this feature doesn't really buy you that much
except for a bit of efficiency, depending on the situation.

dave

Wojciech Sobczuk

unread,
Jul 25, 2002, 6:25:44 PM7/25/02
to
Well, it buys you a lot of efficiency compared to deferred retrieval.

For example if you have these classes (simplified):
message
from-user-id
to-user-id
body

user
id
name

Try fetching all the messages and the respective from/to users with
deferred retrieval. You'll end up with 1 query to fetch the messages,
and then 2 queries per message to fetch the from/to users. And it could
have been all done in one query with immediate retrieval.

Or am I not understanding something?

Greetings,
Wojtek

Marc Spitzer

unread,
Jul 25, 2002, 5:17:07 PM7/25/02
to
In article <7u65z3s...@piracy.red-bean.com>, Craig Brozefsky wrote:
> Wojciech Sobczuk <woj...@nemo.pl> writes:
>
>> Ok, take that back. It's on the TODO list. I'm screwed.
>
> In all honesty, while it may be in the TODO list, I doubt it will
> get done unless you or someone else does it.

So he can replace screwwed with motivated?

marc

0 new messages