Jens Gerhardt
Jens Gerhardt
@jensger.bsky.social
Reposted by Jens Gerhardt
Processing one row at a time leads to lots of round-trips to the #database

This is SLOOOOOOOW

It's faster to batch records and send many in one call

How much faster?

@pdevisser.bsky.social tested with Python and batching inserted 150x more rows!
oracle23ai and python - eliminate RoundTrips.
TL;DR: Searching for RoundTrips to eliminate between python and Oracle. In this case, we "collect" the individual inserts to do them in a fe...
buff.ly
October 7, 2025 at 11:03 AM
Reposted by Jens Gerhardt
Freiburg, Germany, Central Station Bookshop (right @the center of the shop‘s entryway):
“This is a selection of books which are banned at schools in the US“.
#UniteAgainstBookBans
#FreedomToRead
@ala-pla.bsky.social
@librarypolicy.bsky.social
April 4, 2025 at 3:55 PM
Reposted by Jens Gerhardt
How close is your application server to your database? What is the Oracle Net roundtrip time? How long does it take to log on? The ociping and connping tools will tell you: github.com/oracle/rwloa... - brought to you by the Real World Performance team. Available for Linux and MS Windows.
Measuring Oracle Net Latency
RWP*Load Simulator - your tool for scripting, simulation and much more. Like having a bit of bash and SQL, a nip of C or Java, a dash of awk, a grain of sed plus drops of secret sauce in one single...
github.com
December 10, 2024 at 4:47 PM
Reposted by Jens Gerhardt
Let's get this started by sharing one of my old data memes to prove I'm not a bot 😄
November 13, 2024 at 10:47 AM
One customer noticed something in the supported Versions for SQL Developer.
www.oracle.com/tools/sqldev...
The 24.x Version is currently not on it, I guess this is only a small oversight?
Any plans on how long development for the Java SQL Developer will continue?
@thatjeffsmith.bsky.social
#SQLDev
www.oracle.com
November 4, 2024 at 8:24 AM
Reposted by Jens Gerhardt
The Starter pack of #Oracle folk is now up to 56 ppl :) Lots of familiar faces, many going all the way back to when I joined the other site back in 2009 🤗

bsky.app/starter-pack...

#dataBS
October 30, 2024 at 9:34 AM
Reposted by Jens Gerhardt
Specialization of labor: A success story for 10000 years.

Today: Full stack developers.

Future civilizations will wonder what went wrong like we wonder about the decline of the roman empire.
March 15, 2024 at 12:14 PM