What is Nostr?
KarlE /
npub17yc…rf2p
2024-03-03 01:01:35
in reply to nevent1q…n572

KarlE on Nostr: npub1gfdrr…x7gg6 npub1slyc6…ut8j7 in the late 1990s I had an SQL "select ... ...

npub1gfdrrw9629qxwvwaa3vwnvzhtaqu2c5m9wf6vcwjnmdnhs7hl4jsux7gg6 (npub1gfd…7gg6) npub1slyc6w2fy6t7sk7e5caxclu2dn629l35n4tkjyxzrqndkpq86x2sfut8j7 (npub1sly…t8j7) in the late 1990s I had an SQL "select ... where a in (1,2,3)", there was an index on a. Using Informix it was fast. Using Oracle - why does this take so long? Turned out,
"a in <literal>" would just not use the index. Rewrote to generate "a=1 or a=2 or a=3" instead, and it ran... 🤦
Author Public Key
npub17yc27rqxhsahpulamf8vafkm4yz56m439djf7n78wrradvrn4s2q4crf2p