[THIN] Re: Publishing Large Access Databases
- From: "TheThin" <TheThin@xxxxxxxxxxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Tue, 4 Feb 2003 15:39:02 -0500
We unfortunately do this with some 300meg access databases. It does
work OK. Going to bonded nics, 2 100mbit full duplex on the terminal
servers, and 4 100megabit full duplex on the file server helped. =20
Maybe you can use this as an excuse to get a 1Gig backbone switch for
your farm? (if you don't already have one!).
I would try to avoid it, or see if the developers can restructure the
code so that a smaller file only queried needed data out of the backend.
If you can't recode, I would throw plenty of bandwidth at it and test
heavily. How many servers and how many users? =20
Access really doesn't like more than 20 - 25 users hitting it natively.
After that, it seems to start requiring rebuilds on a regular basis. If
this is something that all of a sudden they want to start pushing out
from 5 users to 500 users through the magic of Citrix, you could be in
for a long summer.
-----Original Message-----
From: Jacob Walker [mailto:ctxrulez@xxxxxxxxxxx]=20
Posted At: Tuesday, February 04, 2003 3:26 PM
Posted To: TheThin
Conversation: [THIN] Re: Publishing Large Access Databases
Subject: [THIN] Re: Publishing Large Access Databases
The extremely terse explanation I received from the project manager does
agree with what you describe below. However, it looks like there are a
lot=20
of tables, linked tables, and queries within the Access database. There
don't appear to be any forms, and there are just a handful of reports.
So,=20
at over 1GB in size, I guess they are storing data in Access, too.
>-----Original Message-----
>From: Greg Reese [mailto:GReese@xxxxxxxxxxxxxxxx]
>Sent: Tuesday, February 04, 2003 3:10 PM
>To: thin@xxxxxxxxxxxxx
>Subject: [THIN] Re: Publishing Large Access Databases
>
>
>
>yuck. Sounds messy.=3D20
>
>So the access databases are just forms and reports that connect to db2=20
>=3D and Informix tables?
>
>Greg
>
>-----Original Message-----
>From: Jacob Walker [mailto:ctxrulez@xxxxxxxxxxx]
>Sent: Tuesday, February 04, 2003 3:03 PM
>To: thin@xxxxxxxxxxxxx
>Subject: [THIN] Re: Publishing Large Access Databases
>
>
>
>My understanding is that these Access database files are arranged with=20
>a =3D
>
>front end and back end database. I believe the back end database from=20
>=3D which=3D20 it pulls data uses a DB2 client connecting to an =
Informix=20
>database.
_________________________________________________________________
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. =20
http://join.msn.com/?page=3Dfeatures/virus
********************************************
This Week's Sponsor: triCerat Inc.
Let triCerat simplify the administration=20
of your Terminal Servers.
http://www.triCerat.com
********************************************
For Archives, to Unsubscribe, Subscribe or=20
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
********************************************
This Week's Sponsor: triCerat Inc.
Let triCerat simplify the administration
of your Terminal Servers.
http://www.triCerat.com
********************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thethin.net/citrixlist.cfm
Other related posts: