Re: [[ADMIN] Tuning questions..]

2001-12-19 Thread Michael T. Halligan
CT count(DISTINCT song_id) FROM ssa_candidate, station_subgenre >WHERE > >SELECT count(DISTINCT song_id) FROM ssa_candidate, station_subgenre >WHERE "Michael T. Halligan" <[EMAIL PROTECTED]> wrote: > >>Hi.. I seem to be running into a bottle neck on a query,

[ADMIN] Tuning questions..

2001-12-19 Thread Michael T. Halligan
Hi.. I seem to be running into a bottle neck on a query, and I'm not sure what the bottleneck is . The machine is a dual-processor p3 750 with 2 gigs of (pc100) memory, and 3 72 gig disks setup in raid 5. Right now i'm just testing our db for speed (we're porting from oracle) .. later on We'r