Re: Alternate for Varrays in Oracle

[carl christianson]

k. forgive my ignorance as I'm relatively new to MySQL, but have been doing heavy db development for quite a while.

How do you populate a temp table in the database from the application layer without incurring a network roundtrip for each row? Certainly doing a batch insert in java helps alleviate this some. But it's orders of magnitude different then sending arrays of values and letting the db engine then sync the data.

Unless mysql has a way to populate a temp table in one transaction efficiently?

The whole point of the question of how to pass an ARRAY of values in my head is because you have data that is not yet present in the database residing in your application layer, and you need to do some sort of processing on that in the database but don't want to have a statement fired for each row of data through the whole stack (app <---> database).