RedBeardLab/rediSQL

Bulk insert

979163895 opened this issue · 5 comments

979163895 commented

Hello, I need a batch insert method?
Maybe a few hundred thousand, maybe more?
Thank you very much!

siscia commented

Hello,

are you a PRO costumer?

Can you please reach me privately with your license so we can discuss your use case?

Best Regards,
Simone

979163895 commented

Thank you, Simone. Besides this,

  1. If RediSQL Pro version support redis cluster?
  2. For Pro version, how faster for batch insert versus community version?

Thanks in advance.

siscia commented

With the PRO version, you are buying my expertise.

There are way to make a batch insert, but it really depends on your architecture and use case.

Redis Cluster is already supported, but each database is a key, so you can have multiple databases clustered, but not different rows from the same database clustered. Does it make sense?

979163895 commented

Regarding "batch insert", if your way like this?
REDISQL.EXEC DB "INSERT INTO baz VALUES(3, 'ccc'),(4, 'ccc'),(5, 'ccc')......;
Is there any way to make parallelism to further accelerate it?

siscia commented

Man there are a lot of way, which is best depends on your use case and architecture.

Feel free to study the documentation and the source code to understand what is best for your own use case.

Alternatively I am available for consultancy.

For quote and pricing feel free to reach me out at simone@redbeardlab.com

Closing now.