Re: Size images

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41972
interpreted = N
texte = I would store the sizes in the database, this will reduce disk activity for the [fileinfo], and willhelp under load. A lookup to the db will be quicker than reading the image from disk. Alain> Hi, > > I'm working on a large Image database 300 000 Images. > To speedup the page loading I'm putting the size off the thumbnails for > each of them. > > I'm not decided between tow solutions. > > 1. Getting the image size for each files each time somebody connect. > [FileInfo file=image/[sku].jpg] > border=0> > [/FileInfo] > > 2 Reading the [FileInfo] on the first time the image is read and > appending the image db with the [ImageWidth] [ImageHeight] > information's. Then reading the image size in the db each time the file > is asked > > > According to all your different experiences, what is the fastest > solution. Appending the db will increase the db size. > > Thanks > > > Lawrence Banahan > Author's Image > Collection Director > lb@authorsimage.com > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is > at: http://search.smithmicro.com/ -- Alain Russell Blackpepper Interactive alain.russell@blackpepper.co.nz ph. 09 520 6280------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Size images (lb Lawrence 2002)
  2. Re: Size images (Kenneth Grome 2002)
  3. Re: Size images (Kenneth Grome 2002)
  4. Re: Size images (Kenneth Grome 2002)
  5. Re: Size images (Aaron Lynch 2002)
  6. Re: Size images (lb Lawrence 2002)
  7. Re: Size images (Aaron Lynch 2002)
  8. Re: Size images (lb Lawrence 2002)
  9. Re: Size images (Velma Kahn 2002)
  10. Re: Size images (lb Lawrence 2002)
  11. Re: Size images (lb Lawrence 2002)
  12. Re: Size images (lb Lawrence 2002)
  13. Re: Size images (lb Lawrence 2002)
  14. Re: Size images (Aaron Lynch 2002)
  15. Re: Size images (Blade 2002)
  16. Re: Size images (Jesse Williams-Proudman 2002)
  17. Re: Size images (Kenneth Grome 2002)
  18. Re: Size images (Alain Russell 2002)
  19. Size images (lb Lawrence 2002)
I would store the sizes in the database, this will reduce disk activity for the [fileinfo], and willhelp under load. A lookup to the db will be quicker than reading the image from disk. Alain> Hi, > > I'm working on a large Image database 300 000 Images. > To speedup the page loading I'm putting the size off the thumbnails for > each of them. > > I'm not decided between tow solutions. > > 1. Getting the image size for each files each time somebody connect. > [FileInfo file=image/[sku].jpg] > border=0> > [/FileInfo] > > 2 Reading the [fileinfo] on the first time the image is read and > appending the image db with the [ImageWidth] [ImageHeight] > information's. Then reading the image size in the db each time the file > is asked > > > According to all your different experiences, what is the fastest > solution. Appending the db will increase the db size. > > Thanks > > > Lawrence Banahan > Author's Image > Collection Director > lb@authorsimage.com > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is > at: http://search.smithmicro.com/ -- Alain Russell Blackpepper Interactive alain.russell@blackpepper.co.nz ph. 09 520 6280------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Alain Russell

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Help name our technology! (1997) Date range (2006) Diners Club card problems (1999) WebCatalog can't find database (1997) how to check for no value while using [URL] to prevent cr (1999) Install problem (Was Bad Install) (2003) creating a 60 fields database (1997) Major Security Hole IIS NT (1998) WebCat2: Items xx to xx shown, etc. (1997) calculating tax rates, mail order solutions and version 2 (1997) Searching multiple fields (1997) shipcost (1997) wrong input values? (1997) James Hawker (1998) Buying sans cart (1997) Dummy Credit Card Number for debug? (1997) Server Load (2000) read and write you own cookies with webcat (1997) Sending order notification by fax (1999) Associative lookup style? + bit more (1997)