On Dec 30, 2004, at 10:25 AM, Judith Barer wrote:
> Now we would like to have our web site reflect the most current data.
> The first
> thought was to upload the data every night. This runs into
> complications
> like I don't really like the idea of overwriting live data and the data
> should really be uploaded to a temp directory and then have the web
> site
> down momentarily for processing and then the tables should be
> overwritten.
> The consultants said that that is very difficult to program. Is that
> true?
> Anyway I know this is definitely not the best way to do this but I am
> the
> only programmer in my office and they do not want to spend a lot of
> money on
> this project.
I would strongly recommend replacing the data store from DBFs to
something that is designed to be accessed over the internet. Almost all
real RDBMSs can do this. Then you simply update your website to connect
to the web-accessible database.
If latency/bandwidth is an issue, then make sure that your new RDBMS
supports replication, and simply set up a replicated copy local to the
webserver.
___/
/
__/
/
____/
Ed Leafe
http://leafe.com/
http://dabodev.com/
©2004 Ed Leafe |
