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:

Weird Linux WebCat Issue (2003) Location of Webcat site in folder hierarchy (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) CAlendar (2003) Great product and great job ! (1997) Setting up shop (1997) 2.1.1 bug (ORDERFILE/SHOWIF/LINEITEMS) (1998) New syntax feedback for 4.0 (2000) .tmp files (2000) Calculating multiple shipping... (1997) NYC-based WebDNA programmers (2003) WebDNA 4.5.1 Now Available (2003) WebCatalog NT beta 18 problem (1997) hiding hyperlink info in URL field (1999) WebCatalog 4.0.2b5 available (2000) WebCatalog for guestbook ? (1997) Nested tags count question (1997) problems with 2 tags shakur (1997) NT lockup (1998) Three new problems, maybe a fourth (1997)