Message-Id: <199706031419.HAA335030@dns.ccit.arizona.edu> Date: Tue, 3 Jun 1997 09:18:42 -0500 From: George Holmes <mailto:george.holmes@MAIL.UTEXAS.EDU> Subject: Re: database construction To: mailto:IMAGELIB@LISTSERV.ARIZONA.EDU
Is there an easy to understand book/tutorial that shows versus explains how to set-up oracle a/o FMP 3.0 on the Web? I'm a *very* visual learner and I hate to wade through a lot of words that are very scholarly/boring. Thanks,
>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)
>> |
>>
George Holmes, MSGT/USAF-Ret Archer M Huntington Art Gallery The University of Texas 23rd and San Jacinto St Austin, Tx 78712-1205 Photographer-Site Designer Ph# 512.471.9194 Fax# 512.471.7023 http://www.utexas.edu/cofa/hag ***********************I will not tolerate intolerance********************