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 activityfor the [fileinfo], and willhelp under load. A lookup to the db will be quicker than reading the imagefrom 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 RussellBlackpepper Interactivealain.russell@blackpepper.co.nzph. 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 activityfor the [fileinfo], and willhelp under load. A lookup to the db will be quicker than reading the imagefrom 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 RussellBlackpepper Interactivealain.russell@blackpepper.co.nzph. 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:
Help name our technology! (1997)
Date range (2006)
Diners Club card problems (1999)
WebCatalog can't find database (1997)
how to check for no value while using [URL] to prevent cr (1999)
Install problem (Was Bad Install) (2003)
creating a 60 fields database (1997)
Major Security Hole IIS NT (1998)
WebCat2: Items xx to xx shown, etc. (1997)
calculating tax rates, mail order solutions and version 2 (1997)
Searching multiple fields (1997)
shipcost (1997)
wrong input values? (1997)
James Hawker (1998)
Buying sans cart (1997)
Dummy Credit Card Number for debug? (1997)
Server Load (2000)
read and write you own cookies with webcat (1997)
Sending order notification by fax (1999)
Associative lookup style? + bit more (1997)