>At 9:36 PM +1000 5/30/1999, Michael Farr wrote:
> >I need to know how this database would perform, before I create it.
> >
> >I will have 20 000 people in the database, each with an average of 8
>images
> >@ 125k each.
> >eg a table with 160 000 images @ 125 k each pointing to another table
>with
> >100 000 records
> >total approx = 20 Gb
-snip-
Here is an idea,
I do *something* like this with an employee file and their *picture*
(mySQL and webmerger), I've also done the same with a 200,000 voter database
and their signatures.
The way out of this is to not store the picture in the database, simply name
the picture a unique id.....the employee id.
example: Fred Smith is employee number 36, where 36 is an auto_increment
ID in a mySQL table. Name his picture 36.jpg, and when it comes time to
display the picture, like on a web based employee app, simply display the
picture by concatinating the employee_ID field with the proper file
extension. Using webmerger generated HTML(like PHP) it would look like this:
<img = #EMP_ID#.jpg>
This is how I do it, you can check out my example:
http://shredder.elen.utah.edu/steve.html
steve
___ _____ ___ ___
(___ | |__ \ / |__
____) | |___ \/ |___
___ __ __ _
|__ /\ /\/\ |__) |__) / \
| /--\ / \ |__) | \ \_/
Steven P. Fambro
KD7BVA
Electrical Engineering Junior
University of Utah
____
___ / |
| |/| |
| | | |_______
|___| | | ---------____________
\|_____|___________________________/
(---------------------------------)
(________________________________)
Builder and pilot of the
UH-10F Hovercraft from
Universal Hovercraft
http://www.bews.com/hover/catalog.htm
_______________________________________________________________
Get Free Email and Do More On The Web. Visit http://www.msn.com
