all, This is to report everyone that the method suggested by John worked and it has improved the performance a lot. (Tim to populate 30,000 records has been reduced from 24 seconds to 10 seconds.)
What I did are as following (1) added attributes to access the FKs directly to the ObjEntity (2) unchecked "Mandatory" checks on the FK fields from the DbEntity I am not happy with needing step (2), while the FKs have NOT NULL constraints, but quite happy with the performance improvement. thanks nobu On 13 July 2016 at 14:10, Harunobu Oyama <h...@telensa.com> wrote: > John, > > Thank you for your swift, took less than 1 minute!, answer. > I will try the method you suggest. > > nobu > > > On 13 July 2016 at 14:07, John Huss <johnth...@gmail.com> wrote: > >> You can expose the fk directly as an attribute / property of the class and >> set it. Then if you don't need it going forward you can remove it and just >> use the relationship. >> On Wed, Jul 13, 2016 at 8:04 AM Harunobu Oyama <h...@telensa.com> wrote: >> >> > Hi, >> > >> > >> > Does Cayenne provide a way to insert records without querying the >> records >> > that the new record refers via its FKs? For example, in >> > Artist-Painting-Gallery sample in the official getting started guide, >> is it >> > possible to insert Painting records without querying Artist or Gallery >> when >> > ARTIST_ID and GALLERY_ID are already known and we do are certain that >> they >> > are valid? I do not care even if the object created gets unstable as >> long >> > as inserting the record succeeds, as it is a part of process to just >> insert >> > records. We will discard the object without referring any of its member >> > once the insertion completes. >> > >> > As a part of performance testing, I am in the middle of populating 3 >> > billions of records on a table with FKs. What is the fastest Cayenne >> way to >> > populate records in such situation? >> > >> > >> > thank you, >> > nobu >> > >> > >
