Kendrick2

4 ms·

1. 1.▲
   by Kendrick2 10y ago

   > 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-mails the result to the user when it's do
2. 2.▲
   by Kendrick2 10y ago

   > 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 entire data set for a big report) and it's very difficul
3. 3.▲
   by Kendrick2 10y ago

   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 time series record to decide how these reports are gener
4. 4.▲
   by Kendrick2 10y ago

   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 when the reports are generated using application logic o
5. 5.▲
   Ask HN: Generating reports on time series data without killing performance?

   5 points by Kendrick2 10y ago|14 comments
6. 6.▲
   by Kendrick2 10y ago

   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 code. The software I develop is pretty large and typically does