I can't wait to tell you to read the documentation
but that includes documentation, which I have pretty much finished
I am up to 225 KB of code
Have you tried writing different types of queries.
Well that's interesting. Thanks.
Well there's the problem. Cardio is stupid.
the process is probably still running though
query concurrency was very low. was just glad it didn't spill
also the screenshot is from a query still in progress. might have used 20% more
I don't know what the rules are, but for My Workload it's uncommon to see a query use more than 85% and not spill
there are many types of queries that can't use their full memory grant without spilling to tempdb
we're meme professionals
that's a word we invented AND implemented
It was quite unwelcoming
I saw that error
it went badly
also I just created a trigger
you should sue
> new concept
Like your mom?
if only all tables were insert only
Get It Right The First Time™
> Blockchain tables are insert-only tables that organize rows into a number of chains and is a new concept starting with Oracle 20c.
paul's mod status in shambles
> Despite having significantly less rows
today i put together one of bob ward's slides
"There is a myth that if a query uses multiple processors it will perform better. It is actually not true."
@Paul what do you think of the new SE moderator agreement (if you've had a chance to check it out)?
hahaha, well yeah, you'd wanna Get It Right The First Time™
probably need another 500 years or so for perspective
too bad you never implemented it :^)
we invented the word 'freedom'
Absent of other context, a query holding onto 400 GB of RAM that it's never going to use seems bad.
still good work though, thanks
if you had done it one week ago then it would have been implemented on America Freedom day
@Joe chat message lockdown [is over](https://topanswers.xyz/meta?q=1178#a1389)
Happy Birthday @Paul!
why's that, young Josh?
it is what it is
an interrupting lamak
Used 437 GB. That seems like a bad ratio.
How much memory does that instance have?!
That's a BIG memory grant.
Enter question or answer id or url (and optionally further answer ids/urls from the same question) from
Separate each id/url with a space. No need to list your own answers; they will be imported automatically.