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:

Emailer file formats (1998) Virtual hosting and webcatNT (1997) Trouble with [Math] (1998) Bug Report, maybe (1997) notification solutions (1997) WebCat + IIS (2001) F2 to F3 rocky transition (1997) Include remote? (1998) displaying New products (Yikes! it's Fixed!) (1997) Help w/Multi User Admins (1997) test (2004) pc (1997) Multiple prices (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) PCS Frames (1997) (1997) Setting up shop (1997) Coding Standards - are there any ? (2003) So Simple (2005) too many nested tags ... (1997)