Large table in ASE 15.0.3

5 pts.
Tags:
Data Tables
Database
Database query
Hello -

I've got a process that loads 56million rows daily (via bcp) into a table, maintaining this data for 30days.  Our company is too cheap to pay for semantic partitioning so i'm wondering if anyone has any ideas on how to make queries respond in a semi-timely manner.  There's one date column, and two other columns that we routinely do a sum() on, by date.  Because of this tables size we can't apply indexes.  (It took several hours and still didn't complete so we scrapped the index idea).  Does anyone have any suggestions on configuration so that we can run a daily query in under two hours?  I've partitioned the table into 31 partitions and each day i load data into a separate partition.  I'm not sure if this will help or not, but i'm experimenting with it for now.  Here's our environment:

Sun Fire X4250 with 2-quad 3.16GHz cpus, with 32GB RAM running on Solaris 10  x86_64 A   -  ASE 15.0.3. ESD#1

 



Software/Hardware used:
Sun Fire x4250 2 x Quad Xeon(R) CPU - 32GB ram
ASKED: March 19, 2010  8:21 PM
UPDATED: March 19, 2010  8:30 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following