=20

	I had a call from a client with a remote office in London (we are
near manchester)
 their db took ages to load and run...
 That would be because it's access, it is loading across a network
vpn connection that is 128k ISDN (it was a while back),
 and you are also loading MSAccess off of the machine at the end of
the vpn, instead of locally...
 easy fix, happy customer,   k-ching!
 On Thu 30/06/11 11:28 AM , Michael Watterson mike@radioway.org sent:
  On 30/06/2011 00:05, smplx wrote:
 >> >
 >> > Thanks! Open/close on an as-needed basis it will be, then. But
at any rate,
 >> > it's a small project with only a few users (not more than two
or three at
 >> > the same time) so I won't be exhausting any modern SQL server
no matter how
 >> > bad I code it.
 > FAMOUS LAST WORDS!
 >
 > :-)
 >
 >
 > Regards
 > Sergio Masci
 At least it's SQL and not Access.
 I've seen some scary "multiuser" databases using Access.
 It DOES matter how you code it even if there is only one user.
 --=20
 http://www.piclist.com [1] PIC/SX FAQ & list archive
 View/change your membership options at
 http://mailman.mit.edu/mailman/listinfo/piclist [2]


Links:
------
[1] http://www.piclist.com
[2] http://mailman.mit.edu/mailman/listinfo/piclist
--=20
http://www.piclist.com PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.