Re: Size images

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 41984
interpreted = N
texte = Shall I rather put the image size in the db in witch I have the captions and keywords or shall I make a separte db.A [lookup] is faster than a [search]. But when I'm already displaying a search in a db isn't it faster to get the file width & height from this same db. le 27/07/02 12:48, Alain Russell à alain.russell@blackpepper.co.nz a écrit :> 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/ > ------------------------------------------------------------- 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)
Shall I rather put the image size in the db in witch I have the captions and keywords or shall I make a separte db.A [lookup] is faster than a [search]. But when I'm already displaying a search in a db isn't it faster to get the file width & height from this same db. le 27/07/02 12:48, Alain Russell à alain.russell@blackpepper.co.nz a écrit :> 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/ > ------------------------------------------------------------- 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/ lb Lawrence

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:

Overseas project (2000) possible, WebCat2.0 and checkboxes-restated (1997) RAM variables (1997) Unformatted Messages (1998) [append] vs. [appendfile] delta + question? (1997) Protect (1997) Lambada for Macintosh is Here! (1996) WebCat2: Items xx to xx shown, etc. (1997) generator prob (2001) Softball questions (2003) Bug Report, maybe (1997) Duplicate Cart ID (2001) New public beta available (1997) Trouble with formula.db (1997) Ready,Set; Print! (1999) multi-paragraph fields (1997) Need help with emailer- 2 issues (1997) raw=T is broken in [include] (1997) WebCat 4.51 on Fedora Core 1 (2004) MySQL question (2005)