[AccessD] "Faked" replication

Hi Steve:

Never trust your spell checker...I meant 'pseudo'.

Graphics, no matter how you cut it, compress it or manipulate it, are large
and time consuming for any operation. That is the reality of graphics.
Working on web sites, I know that as much time is spent on optimizing the
graphics as is spent on writing the code. For the best performance, graphics
should be stored external from the application, linked and a graphic image
should not exceed 50K...good rule of thumb. There is some 'chunk' buffer
issue, 64K, 128K, 256K.. but I am not sure of the details and some of the
other list members can fill in any further information.

If your graphics files are not Access defaults (I am not sure whether jpg
and gif files are considered defaults but I think bmp and some other M$
specific extensions are...) the program embeds a copy of the display drive
in each record. I took over a MDB after a major crash which was precipitated
by the file apparently hitting the 2 GB wall, in only three months. When the
graphic files were setup as linked the MDB reduced to about 150MB.

You may have already taken steps around this issue but thought I would give
you a heads up anyway.

HTH
Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Steven W.
Erbach
Sent: Monday, December 22, 2003 9:28 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] "Faked" replication


Jim,

>> PCAnywhere, for all its weirdnesses does create a suede VPN <<

Suede?!? A little mis-typing there or is this a new, hip adjective?

The host system that my client has is on a cable modem, so that's no
problem. However the remotes will all be dial-up. Does this present any
problems? I used PCAnywhere v. 8 quite a lot with dialup a few years ago to
do remote control work on a client's system. But what you're suggesting here
is a "live" replication, not indirect.

My main concern with this is the number of graphi images added to the
database. I've trained the users to make sure that all the graphics are
converted to GIFs before being pasted into Access...but there will still be
a significant number of them.

This looks workable. I'm meeting with my client tomorrow morning and I will
suggest it to him after eating some humble pie regarding my too-optimistic
presentation of Replication as a good tool for his situation.

Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
920-969-0504

Message created with Bloomba

Disclaimer: No tree was killed in the transmission of this message. However,
several coulombs of electrons were temporarily inconvenienced.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com