in reply to Re^6: Perl Contempt in My Workplace
in thread Perl Contempt in My Workplace
JSONs are not possible for 10_000_000 records
As hippo says, JSON is just a data format.
Let's give it a try, testing with some generated md5 values:
testdb=# select count(*) from vkon_json; count ---------- 10000000 (1 row) testdb=# select * from vkon_json limit 3; js | id --------------------------------------------+---- {"f1": "c4ca4238a0b923820dcc509a6f75849b"} | 1 {"f1": "c81e728d9d4c2f636f067f89cc14862c"} | 2 {"f1": "eccbc87e4b5ce2fe28308fd9f2a7baf3"} | 3 (3 rows) -- retrieve: testdb=# select * from vkon_json where js @> '{"f1": "d1ca3aaf52b41acd68ebb3bf69079bd1"}'; js | id --------------------------------------------+---------- {"f1": "d1ca3aaf52b41acd68ebb3bf69079bd1"} | 10000000 (1 row) Time: 0.679 ms
Less than half a millisecond. What do you think? Possible?
(I could have put everything into a 1-column, 1-row table but that just seems too dumb. Possible, though, and will perform just as fast)
|
---|
Replies are listed 'Best First'. | |
---|---|
A reply falls below the community's threshold of quality. You may see it by logging in. |
In Section
Meditations