Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
MIME-Version: 1.0
From: Harunobu Oyama <ho@telensa.com>
Date: Wed, 13 Jul 2016 14:04:32 +0100
Message-ID: <CADYwi8jBwuwWr6svMDTPwvfrsg656Ftn9AHw0vE7w==yCkHx3w@mail.gmail.com>
Subject: Inserting records without querying the relations
To: user@cayenne.apache.org
Content-Type: multipart/alternative; boundary=001a113fb55ccd9929053784062e
archived-at: Wed, 13 Jul 2016 13:04:39 -0000

--001a113fb55ccd9929053784062e
Content-Type: text/plain; charset=UTF-8

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

--001a113fb55ccd9929053784062e--