Viewing profile — Kendrick2

> If it's not possible to do a few big queries... Yeah, this is the unfortunate conclusion that I arrived at too. I'm looking at making these reports go through a job queue which e…

> Have you tried loading all the data required... Sorry, I probably edited my post while you were typing. The amount of data to load is theoretically unbounded (could load the enti…

Complex domain-specific requirements preclude simple joins unfortunately. This is why I'd like to redevelop these queries in C#. There are many imperative steps performed on each t…

Yes currently all the reports operate quite efficiently on a set of indexes. The performance of the database is currently very good with the reports in PL/SQL. The problem arises w…

I have an application which contains approximately 10 million time series records growing at a rate of 1 million per year. This application generates reports on subsets of the time…

How do web applications explode out to 3 Million lines of code? Yelp, to me, looks like a typical CRUD app and I would have been surprised if it were more than 100,000 lines of cod…