search

cockroachdb / loadgen

CockroachDB load generators
Apache License 2.0
30 stars 25 forks source link

rand: option for using dynamic SQL instead of prepared statement #90

Open robert-s-lee opened 7 years ago

robert-s-lee commented 7 years ago

prepared statement has limit of 64K parameters. Add an option for using dynamic SQL instead of prepared statement.

jordanlewis commented 7 years ago

What do you mean by dynamic SQL?

Also, using more than 64k parameters seems suspicious :) is it ever useful to have batches that large?

robert-s-lee commented 7 years ago

Instead of using prepared statement, issue insert into x values (1,2,3),(4,5,6)…. If the throughput continues to get better beyond 64K parameters, then this would be a viable way for bulk operation.

On Oct 24, 2017, at 4:37 PM, Jordan Lewis notifications@github.com wrote:

What do you mean by dynamic SQL?

Also, using more than 64k parameters seems suspicious :) is it ever useful to have batches that large?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/cockroachdb/loadgen/issues/90#issuecomment-339123374, or mute the thread https://github.com/notifications/unsubscribe-auth/AGBcdExWvgU-eS-n5mggOmPi3fHZ34Y4ks5svkqQgaJpZM4QFCae.