krizma5683
Technical User
I have a database that imports daily records from our meter reading department. The system our meter reading data is loaded to is a mainframe system and the only way to extract data is through Crystal Reports & SAS. I'm using the extracted data to load into the database (approx. 42,000 records daily) and then through queries I'm performing additional calcs & lookups to generate monthly reports.
However, January - mid-April has already created 3 million records in my database and now none of my queries will run. They all time out saying that I don't have enough temporary space. I'm afraid this issue will only get worse throughout the year.
Can someone give me suggestions or point me to some discussion forums that may help me use these millions of records to still create my excel pivot table reports???
However, January - mid-April has already created 3 million records in my database and now none of my queries will run. They all time out saying that I don't have enough temporary space. I'm afraid this issue will only get worse throughout the year.
Can someone give me suggestions or point me to some discussion forums that may help me use these millions of records to still create my excel pivot table reports???