workaround? : Limit in subquery not allowed

Hi, I'm doing some clientside aggregation on rows (which represent prices ) which sit in a huge table. I therefore want to import these rows in chunks, but for this aggregation code to operate correctly I need to be sure that all prices of a certain product are contained in the same chunk. To

increase with inserts/updates in partitioned table when knowing which partition?

Hi, I have a partitioned table using hash. For the example lets say I have N partitions. Selects perform well due to the partitioning. However I noticed that inserts and updates slow down considerably when the number of partitions goes up. (I think because if needs to inspect / open all partiti

fast insert/update on partitioned table using hash

Hi, I have a partitioned table based on hash, like so: PARTITION BY HASH(id1) PARTITIONS 1000; I have lots and lots of rows (therefore the high number of partitions) and since id1 is auto-incremented the distribution is pretty even. The problem is that every night I need to update all rows in