|
|
|
Re: [CDO/DBStore] [message #1021045 is a reply to message #1021018] |
Tue, 19 March 2013 12:33 |
|
Am 19.03.2013 12:27, schrieb Joe Sobeos:
>> DBStore is always generating cross (-> unnecessary joins...) tables (E1_E2_LIST) >> Yes.
>
> Why?
Mostly because noone has spent effort on optimizing the performance of these. Unordered one-to-many references could be
mapped to foreign keys that point in the *opposite* direction. That's not just a minor code change and not everybody
might want to have that.
>
>> It is mapped without unnecessary cross tables if flagged as Transient
>>> By "it" you mean the EStructuralFeature?
>
> EReferences are mapped without ...
Single-valued, you mean? Yes, they're mapped like attributes.
>
>> (why is it stored here anyway?), Why is what stored?
>
> Why are EReferences flagged as Transient stored anyway?
You may have overlooked my question above.
>
>> but then the data is not loaded. (using Transient)
>>> What data?
>
> getEReferenceXYZ() is returning an empty list.
I hoped you take the effort to describe more of your model and your application, so that I'm able to understand what
your problem is. But you didn't ;-(
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
|
Re: [CDO/DBStore] [message #1021802 is a reply to message #1021761] |
Wed, 20 March 2013 17:58 |
|
Am 20.03.2013 17:25, schrieb Joe Sobeos:
>> I hoped you take the effort to describe more of your model and your application, so that I'm able to understand what
>> your problem is. But you didn't ;-(
>
> My problem is that CDO/DBStore does not care about performance. Especially about the count of executedsql queries.
> The "1:n relationships" implementation is only one example.
I agree, it would be awesome to have a better mapping for the unordered 1:n case. It just a lot of effort that noone has
done, yet.
What are the other examples?
> I don't see why you need more information about the model.
Ok.
> I asked two simple questions.
>
> The first question is answered, but I still don't understand why CDO/DbStore is storing EStructuralFeatures flagged as
> Transient in the database.
I don't think it does and you didn't provide more evidence/infos for your assertion.
> For me Transient means do not serialize and do not store to database,
Yes.
> but perhaps here I'm wrong.
No.
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
Cheers
/Eike
----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper
|
|
|
Powered by
FUDForum. Page generated in 0.02806 seconds