The Heap™ – Consultancy ©®

« first day (3611 days earlier) ← previous day next day → last day (1262 days later) »

jcolebrand

3:39 AM

@Minsky What are your parameters?

Can you host it in a cloud vendor or locally? Are you trying to do a proof of concept?

You could run an EC2 to back a mongo instance, or just build a local virtual lab with docker

Can you help us understand what it is you hope to accomplish and what your limitations are?

3 hours later…

John aka hot2use

6:44 AM

Morning

My Windows history:
DOS 6.2 with Windows 3.11 for Workgroups *) [+Norton Utilities]
Windows 95 Beta
Windows 95
Windows NT 4.0 with SP 6a *)
Windows 98 SE *)
Windows 2000
Windows XP
Windows Vista
Windows 7 *)
Windows 10

*) Would do it again

2 hours later…

Andriy M

9:11 AM

Morning

John aka hot2use

9:48 AM

-1

Q: Why isn't LIMIT working in window function (tsql)?

I need to populate temporary table with data from another table. Since I need only data from the last several days I want to somehow limit the data to the last 10 rows. The query works really slow with order by desc and I thought LIMIT would help but I am doing it wrong obviously since it does no...

Ahem....

2 hours later…

User1973

11:39 AM

Hi folks. Any book recommendations for explaining how SQL query performance works?

(novice level; Oracle 12c)

In other words, I’m new to explain plans. I’d like to learn how to tune my queries properly. Thanks.

1 hour later…

mustaccio

12:41 PM

Oracle docs aren't half bad at it.

And the classic: books.google.ca/books/about/…

Max Vernon

1:27 PM

morning

Paul White

2:19 PM

Morning

McNets

2:35 PM

Morning

1 hour later…

Max Vernon

4:03 PM

@MaxVernon How can I give exact details about the json structure and queries if they are freely set by customers? The question is about handling arbitrary key-values (not known in advance). For simplicity, we can now assume that only strings and numbers can be used as values, json is not nested and the queries can be any combination (AND, OR, NOT) of key = value, key < value, key > value... — collimarco 7 mins ago

nice.