INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Can i use Mimer for large size DB and long time?

Can i use Mimer for large size DB and long time?

(OP)
Hello again!
I need to store 300mln records in database with structure as shown below for 3 years without maintenance.
CREATE TABLE KWperHOUR(
    SAMPLE_DATE    TIMESTAMP    NOT NULL,
    OBJECT_CODE    NUMERIC(11,0)    NOT NULL,
    NODE_CODE    NUMERIC(11,0)    NOT NULL,
    SAMPLE_VALUE    NUMERIC(38,10)    NOT NULL,
    STATUS_CODE    NUMERIC(5,0)    NOT NULL,
    PRIMARY KEY(SAMPLE_DATE, OBJECT_CODE, NODE_CODE),
    FOREIGN KEY(OBJECT_CODE, NODE_CODE) REFERENCES NODES(OBJECT_CODE, NODE_CODE) ON DELETE CASCADE ON UPDATE NO ACTION)
and so on...
Intensive INSERT operation (approx. 150.000 records per day).
Large SELECT from two and more linked tables by some (1-10) simultaneously users.
If you have experience with large DB on Mimer - let me know - what kind of experience!
Thanks,
Mihail. :)

RE: Can i use Mimer for large size DB and long time?

In general I would say yes. You have to look into the details a little first and do some testing.

I use Mimer in a commercial site administrating transactions and authorization and that kind of stuff. The biggest table is 13 milion records and it works great. And with just one stop in two years.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close