http://qs321.pair.com?node_id=11133211


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.