Forum: Building VoltDB Applications

Post: Performance consequences of using a key size of 1 MB

Performance consequences of using a key size of 1 MB
eforen
Dec 18, 2010
Hi,
I understand the max key size (varchar) is 1 MB.
I would like to know what are the performance consequences of using these key sizes.
Thank you,
Oren
Oren, This is a very general
rbetts
Dec 21, 2010
Oren,
This is a very general question - the answer is really "it depends." If you transfer these keys between client and server frequently, the network may be the bottleneck (you can't transfer that many 1MB keys per second). I'm assuming that if these are really keys, clients will have to send them to the database to find or address the corresponding data (values).
Honestly, we haven't built any performance testing applications with keys of this size. We're curious to hear more about your application to understand why a structure with such large key sizes is desirable.
*--Ryan