List:General Discussion« Previous MessageNext Message »
From:Steve Fambro Date:May 30 1999 7:25pm
Subject:Re: Performance
View as plain text  

>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
Thread
PerformanceMichael Farr30 May
  • Re: PerformanceSasha Pachev30 May
    • Re: PerformanceTracy R Reed1 Jun
      • Re: PerformanceVivek Khera1 Jun
        • Re: PerformanceDavid Christian1 Jun
  • Re: PerformancePaul DuBois30 May
  • Re: PerformanceSasha Pachev1 Jun
Re: PerformanceSteve Fambro30 May
Re: PerformanceL. Stapinsky1 Jun