cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Musall, Maik" <m...@selbstdenker.ag>
Subject Re: Truncating a table
Date Thu, 21 Dec 2017 12:48:52 GMT
Hi Michael,

how to deal with the caches is basically my actual question. Ideally, I'd like to call something
like myentity.truncateTable(), and just have all data deleted and all caches purged by that,
but of course that doesn't exist yet.

Maik


> Am 21.12.2017 um 13:13 schrieb Michael Gentry <blacknext@gmail.com>:
> 
> Hi Maik,
> 
> Raw SQL would certainly be the most efficient way.  Even if you didn't use
> raw SQL, though, how were you planning on dealing with Cayenne's caches?  I
> think this issue would, regardless of how you truncated the table.  There
> are various options, I'm just trying to get a feel for your use can and
> thoughts.
> 
> Thanks,
> 
> mrg
> 
> 
> On Thu, Dec 21, 2017 at 5:10 AM, Musall, Maik <maik@selbstdenker.ag> wrote:
> 
>> Hi,
>> 
>> I have a lookup table with >400k rows that I want to periodically refill
>> from external sources. Since it also contains precomputed values that are
>> not part of the external source, my plan is to read the external data and
>> batch-insert it all into the table.
>> 
>> How can I truncate the entire table to prepare it for new inserts? The
>> only thing that comes to mind is raw SQL, but that would obviously leave
>> stale data in Cayenne's various caches.
>> 
>> Thanks
>> Maik
>> 
>> 


Mime
View raw message