1.5 hours to create index

IWETHEY v. 0.3.0 | TODO

1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User

Welcome to IWETHEY!

Post #20,015

by broomberg

12/2/01 10:53:57 PM

1.5 hours to create index

On almost unique id.
As opposed to 13 minutes on Sun/Oracle.

Now I'm trying to create 7 indexes simultaneously.

I suspect I will find there is 1.25 hours overhead,
and then each index will be 15 minutes. If that
is true, and the query times are OK, we have
a winner.

Actually, if EACH one takes 1.5 hours, and it runs
overnight once a month, and it saves $80,000, we
still have a winner.

MySQL vs Oracle question - (broomberg) - (23) - Dec. 2, 2001, 09:37:16 AM EST

Other things to consider: - (admin) - (14) - Dec. 2, 2001, 11:45:06 AM EST

Re: Other things to consider: - (broomberg) - (6) - Dec. 2, 2001, 12:08:04 PM EST

Interbase "seen" as going away... - (admin) - (5) - Dec. 2, 2001, 03:34:21 PM EST

Re: Interbase "seen" as going away... - (broomberg) - Dec. 2, 2001, 07:41:07 PM EST

PostGreSQL setup/complexity - (broomberg) - (3) - Dec. 3, 2001, 08:18:29 PM EST

Yep. - (admin) - (2) - Dec. 3, 2001, 08:58:00 PM EST

Re: Yep. - (broomberg) - (1) - Dec. 3, 2001, 09:42:28 PM EST

Shouldn't need one right away. - (admin) - Dec. 3, 2001, 11:07:27 PM EST

Wierd create index behaviour - (broomberg) - (6) - Dec. 2, 2001, 12:36:13 PM EST

index create - (boxley) - (5) - Dec. 2, 2001, 08:04:05 PM EST

Re: index create - (broomberg) - (4) - Dec. 2, 2001, 09:09:04 PM EST

Well, Sybase still has some money - (tonytib) - Dec. 2, 2001, 09:39:52 PM EST

Re: index create - (broomberg) - (2) - Dec. 2, 2001, 10:27:47 PM EST

1.5 hours to create index - (broomberg) - Dec. 2, 2001, 10:53:57 PM EST

That's why I'd second the Interbase recommendation - (tseliot) - Dec. 3, 2001, 03:28:05 PM EST

Re: MySQL vs Oracle question - (wharris2) - (2) - Dec. 3, 2001, 12:47:34 AM EST

Readonly - (broomberg) - (1) - Dec. 3, 2001, 07:09:48 AM EST

Readonly? Hell, then, full speed ahead! -NT - (wharris2) - Dec. 6, 2001, 07:41:13 PM EST

14 hours later, still indexing - (broomberg) - (2) - Dec. 3, 2001, 02:08:57 PM EST

20 hours later, still indexing - (broomberg) - (1) - Dec. 3, 2001, 08:15:59 PM EST

Wheeee - Done!!! - (broomberg) - Dec. 3, 2001, 11:03:46 PM EST

New design - (broomberg) - (1) - Dec. 5, 2001, 08:58:34 PM EST

Happy Ending! - (Meerkat) - Dec. 6, 2001, 06:01:45 PM EST

iwethey.org

Dude?
94 ms