[AccessD] Access XP and 97 hang on reattaching linked tables under WinXP

Drew Wutka DWUTKA at marlow.com
Tue Mar 4 11:58:01 CST 2003


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



More information about the AccessD mailing list