Message-Id: <199706030532.WAA305808@dns.ccit.arizona.edu> Date: Mon, 2 Jun 1997 22:24:54 -0700 From: Mike Betz <mailto:betz@WLN.COM> Subject: Re: database construction To: mailto:IMAGELIB@LISTSERV.ARIZONA.EDU
I would caution against using Access with "millions of photographs". There seems to be a limit around 500,000 where Access craps out, and the database self-destructs. Also, at half a million rows, queries can take up to 20 minutes against non-indexed fields. For a project this size use a real database, say MS SQL or Oracle.Mike Betz mailto:betz@wln.com
On Mon, 2 Jun 1997, Patricia Bruce wrote:
> Hello Katalin....I am doing the same thing here in Texas, but with millions of
> photographs. I will be happy to correspond with you via E-mail, concerning
> any questions you may have. We also are using Access, 7.0 under Office 97,
> and will be planning our collection for in-house cross platform use as well as
> use on the Web. Good luck and welcome!
> Patricia Bruce
> Southwest Research Institute
> San Antonio, Texas
>
> Katalin Fur <mailto:katalinf@ROM.ON.CA> Wrote:
> |
> | Hello Everyone,
> |
> | I am an intern at the Royal Ontario Museum and my
> | summer project
> | involves creating a finding aid for item-level
> | description of 1200
> | archival photographs. A selection of these will be
> | digitized and the
> | finding aid will be available at our web site. It is
> | hoped that the
> | successful outcome of this initiative will lead to
> | the addition of
> | other finding aids from the collection. I will be
> | using MS Access and
> | would appreciate all advice concerning appropriate
> | field designations.
> | Thanks in advance
> |
> | Kathy Fur (mailto:katalinf@rom.on.ca)
> |
>