William Hindman
wdhindman at bellsouth.net
Tue Mar 4 13:24:00 CST 2003
...had I not seen the screen you sent me off list, I'd not have believed it :) ...but now I have to go and do some experimenting to see if I can make this play in SBS2K as well ...thanks :) William Hindman ----- Original Message ----- From: "Drew Wutka" <DWUTKA at marlow.com> To: <accessd at databaseadvisors.com> Sent: Tuesday, March 04, 2003 1:52 PM Subject: RE: [AccessD] Access XP and 97 hang on reattaching linked tables under WinXP > Yes and No. The OS can't be on the RAID 5 itself. But it certainly can be > on the same physical disks as a RAID5. You are limited to only setting it > to a Mirror (You can't get it striped too, which would be a RAID 5). > > Does that make sense William? > > Drew > > -----Original Message----- > From: William Hindman [mailto:wdhindman at bellsouth.net] > Sent: Tuesday, March 04, 2003 12:16 PM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Access XP and 97 hang on reattaching linked > tables under WinXP > > > ...so you've implemented a software RAID5 in Win2K using only three drives? > ...to the best of my knowledge the Win2K OS can't reside on any of the hard > drives configured as RAID5 by its software ...lord knows it would save some > nice change in controller costs :) > > William Hindman > > ----- Original Message ----- > From: "Drew Wutka" <DWUTKA at marlow.com> > To: <accessd at databaseadvisors.com> > Sent: Tuesday, March 04, 2003 12:57 PM > Subject: RE: [AccessD] Access XP and 97 hang on reattaching linked tables > under WinXP > > > > Easy, actually. My personal computer at work.... > > > > Two 20 gig IDE drives and 2 18 gig SCSI drives. Configured as such: > > > > C: (System Root) 6 gigs mirrored (both SCSI drives). > > D: (My Data Drive) 22 gigs (11 gigs on both SCSI drives and 11 gigs on one > > of my IDE drives (the permanent one...the other IDE is removable) > > P: (Program Files) 6 gigs on permanent IDE drive > > Z: (Backup Data) Entire 20 gig removable IDE drive. > > > > > > My 'server' at home: > > > > One 16 gig IDE, two 30Gig IDE and one 60 gig IDE. > > > > C: (system root) 6 gigs mirrored on one of the 30 gigs and the 16 gig. > > D: (Storage)98 gigs spanned on the other 30 gig, the 60 gig, and the > > remainder of the first 30 gig drive. > > E: (Data) 20 gigs striped between the first 30 gig and the 16 gig. > > > > All of the above is done using Windows 2000 Disk Management. I would like > > to have a RAID5 at home, but I needed the space...I'm practically full on > my > > storage drive. > > > > The problem with running a RAID 5 on IDE, is that typically you only have > 2 > > IDE controllers. So running three disks for the same drive can work, but > > it's not practical, since you are sacrificing speed. However, you can buy > a > > PCI IDE controller, so you can then have three IDE drives that are NOT on > > the same controllers. > > > > Drew > > > > -----Original Message----- > > From: William Hindman [mailto:wdhindman at bellsouth.net] > > Sent: Tuesday, March 04, 2003 11:16 AM > > To: accessd at databaseadvisors.com > > Subject: Re: [AccessD] Access XP and 97 hang on reattaching linked > > tables under WinXP > > > > > > ...lol ...I'm still wondering how you "Get three hard drives. (SCSI...but > > that may be a bit expensive....), Mirror the OS, and RAID a data drive > (you > > can do all of that in Disk > > Management...with Windows 2000, no RAID controller necessary.)" ...this > must > > be a Drew style RAID configuration that would leave the people at MS > gasping > > in amazement! :)))) > > > > William Hindman > > > > ----- Original Message ----- > > From: "Drew Wutka" <DWUTKA at marlow.com> > > To: <accessd at databaseadvisors.com> > > Sent: Tuesday, March 04, 2003 11:57 AM > > Subject: RE: [AccessD] Access XP and 97 hang on reattaching linked tables > > under WinXP > > > > > > > Hmmmm, not a bad idea for a new 'cheap' brand name server .... "Drew > > style" > > > .... > > > > > > Drew > > > > > > -----Original Message----- > > > From: Gustav Brock [mailto:gustav at cactus.dk] > > > Sent: Tuesday, March 04, 2003 9:41 AM > > > To: Seth Galitzer > > > Subject: Re: [AccessD] Access XP and 97 hang on reattaching linked > > > tables under WinXP > > > > > > > > > Hi Seth > > > > > > I can't believe you're still struggling with this. We have never > > > encountered a scenario that comes even close to what you describe. > > > > > > Which protocol(s) are you running? > > > Have you tried setting up an isolated test environment? > > > (You can use a "Drew style" server for this!) > > > > > > Don't you have a nearby Novell/database guru to work with on this? > > > > > > /gustav > > > > > > > > > > Relinking to a BE on Novell is panifully slow even on Win98 machines. > > > > I've tried optimizing it, but it still takes up to four seconds for > each > > > > table on Win98, and even longer on 2K or XP machines. Unfortunately, > > > > the problem doesn't appear to be the relinker itself. Using the > > > > built-in Linked Table Manager is still painfully slow. As a result I > am > > > > "this close" to moving everything to a real database server and using > > > > ODBC. Of course, ODBC is likely to introduce its own performance hit. > > > > > > > I would love to have a discussion on this topic. > > > > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > _______________________________________________ > > > AccessD mailing list > > > AccessD at databaseadvisors.com > > > http://databaseadvisors.com/mailman/listinfo/accessd > > > Website: http://www.databaseadvisors.com > > > > > > > > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >