Hi
I have done some more profiling and testing.
executing queries on table with >10 records, directly on server
(not on client) gave results as listed below:
1) SelectQuery(Student.class) with page size 10 takes 30-50 seconds.
2) SQLTemplate(Student.class, "SELECT #result('id' 'int') fro
Hi,
sometimes we are loosing references to one to one reference in Cayennen
objects.
The database allways have these objects.
Datamodell
Product has n ProductStateallways ok
Product basic data type allways ok
Product has a Client sometime not set in Product o
Hi Andrus
I had not much time to check, but with the fix the 100k records load
in 30 instead of 50 seconds. It is some improvement, but not enough.
I'll do some more profiling tomorrow and let you know.
By the way, we are using netbeans for profiling, the benefit : it is
free. I will eval
The only thing I have to add at this point is that with frameworks such as
Cayenne, there is less benefit in trying to put all data in the same
database, so
perhaps in the future we're going to see more rather than less
applications sitting
on top of heterogeneous databases?
Converting databases
On Jun 21, 2007, at 6:15 PM, Mike Kienenberger wrote:
but there's no reason that Cayenne could not attempt to
solve it down the road.
+1. I think we can devise a sensible algorithm along the following
lines:
* Split the qualifier into DB-specific parts
* Fetch the root entity with its ow
I think the limitation has been mostly explained by others in this
thread. So let me try to summarize:
[works] Saving of related objects.
[works] Resolving a relationship.
[doesn't work] Doing a query on relationship source qualified on some
criteria applied to the target object
Yeah, I'd say using 'validateFor...' is the right way to do it in 2.0:
http://cayenne.apache.org/doc20/dataobject-validation.html
Andrus
On Jun 24, 2007, at 11:19 PM, Lachlan Deck wrote:
On 22/06/2007, at 7:41 PM, Thomas Gilbert wrote:
Using Cayenne (2.0) I'm trying to put in place the foll
