I'd like to use GigaBASE with measurement data. Each record will be identified by a device ID (int4), a sensor ID (int4) and a measurement time (dbDateTime -> int4). These three fields together makes the record unique. As documentation says GigaBASE doesn't enforce unique constraint, so I'm wondering what is the fastest way to insert new records while preventing duplicates. Do I always have to query for existence of the new record before I can insert it? Because a hash could be optimized with the UNIQUE key param, would it be a good idea to create a additional field to store a hash of the three fileds above to make that query faster?
Regards
Knut
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello
I'd like to use GigaBASE with measurement data. Each record will be identified by a device ID (int4), a sensor ID (int4) and a measurement time (dbDateTime -> int4). These three fields together makes the record unique. As documentation says GigaBASE doesn't enforce unique constraint, so I'm wondering what is the fastest way to insert new records while preventing duplicates. Do I always have to query for existence of the new record before I can insert it? Because a hash could be optimized with the UNIQUE key param, would it be a good idea to create a additional field to store a hash of the three fileds above to make that query faster?
Regards
Knut