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:

[WebDNA] Permissions changing of .db (2013) Missing contexts on NT (1997) [WebDNA] Attack? (2015) sku not found (1997) Using webcat to roll apache logs (2002) Access Denied! But why? (1997) WCf2 and nested tags (1997) PCS search results page (1998) Use of Back and Reload Buttons on ShoppingCart page? (1997) Cart Question (1998) listfile options (1997) Protect and Serve (1999) SSL (1998) did I miss anything (1997) [WebDNA] Moving sites to a HostGator dedicated server (2008) WebCat2 several catalogs? (1997) Am I going senile? (Price recalc based on quantity) (1997) Urgent WebCatalog problem (2000) server2003 (2004) question: writing files textb in webmerch (1997)