Re: SQL code optimization
Quote
My data has to be displayed on a time-based graph, and I need to sometimes show more than a week of data.
My issue here is that I store an entry every 2 minutes, which means there is too much data to deal with when 7 days are displayed.
One record every two minutes is 30 per hour, 720 per day, 5040 per week. That's really
not a lot in database terms.
Show us "show create table abc \g" of the table that you're querying and the SQL that you're running to retrieve the data.
Regards, Phill W.
Subject
Written By
Posted
September 01, 2015 07:24PM
September 02, 2015 05:27AM
September 02, 2015 10:01AM
Re: SQL code optimization
September 01, 2015 05:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.