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:
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:
Applescript error (1998)
Newbie Tax Question (1997)
Exclude by date - multiple (1997)
Multi Actions (1999)
SSL data to/from webcatalog? (2000)
help needed: Non-english characters in WebCatalog (1997)
Configuring E-mail (1997)
GoLive CyberStudio 1.0.1 (1997)
Multiple transactions per cart (2000)
Rams SuperBowl Champs (2000)
eCommerce software pricing (1998)
Euca Links Manager (2003)
[OT] DOD again (2003)
Dumb Question about Docs (1997)
WebCat/CyberStudio Compatibility (1998)
Help!!!! (1999)
Sandboxes (2004)
Problems with cybercash (2000)
Country & Ship-to address & other fields ? (1997)
docs for WebCatalog2 (1997)