Not going anywhere for a while

Malcolm · Post by **Malcolm** » Fri Sep 30, 2005 4:06 pm

17 million row SQL query, I can't edit the MOTHERFUCKING, GODDAMN table keys or indices.

DoctorChaos · Post by **DoctorChaos** » Sun Oct 02, 2005 10:06 pm

If that happens again you can open up another session and drop or add indices as needed. The performance will improve instantly, at least it did in Oracle.

Post by **GORDON** » Sun Oct 02, 2005 10:22 pm

Bust it into 2 db's?

What's the issue?

Malcolm · Post by **Malcolm** » Mon Oct 03, 2005 2:46 am

I don't get to touch the databases, really. I got update & retrieval privs only.

Post by **GORDON** » Mon Oct 03, 2005 9:58 am

I'm not really sure what you're specifically doing...

Write an SQL to write the entire db into your own test db, then bust it into managable chunks.

Or whatever.

Post by **TheCatt** » Mon Oct 03, 2005 10:23 am

What DB u using anyways?

Paul · Post by **Paul** » Mon Oct 03, 2005 11:54 am

You should FTP the SBD or it'll BF a mauve SQL database.

Um... I don't program at all, but I wanted to contribute.

Malcolm · Post by **Malcolm** » Mon Oct 03, 2005 6:43 pm

I'll just yell at the lead techie to put more indices.

Post by **Troy** » Mon Oct 03, 2005 6:57 pm

I'll contribute too,

I think you should DHL overnight to Canada, and then RSVP for the YMCA Q&A.

Post by **GORDON** » Mon Oct 03, 2005 7:42 pm

Have you tried to just GFY?

Paul · Post by **Paul** » Tue Oct 04, 2005 9:05 am

Have you tried to just GFY?

You only tell people to do that if they don't RTFM.