Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much

[OT] Re^7: Perl Contempt in My Workplace

by erix (Prior)
on May 28, 2021 at 10:53 UTC ( #11133211=note: print w/replies, xml ) Need Help??

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.

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11133211]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (3)
As of 2023-06-04 10:38 GMT
Find Nodes?
    Voting Booth?
    How often do you go to conferences?

    Results (20 votes). Check out past polls.