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
