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:
Exclude by date - multiple (1997)
WebCommerce: Folder organization ? (1997)
Merging LineItems (2003)
Quit revisited (1997)
WebCatalog2 Feature Feedback (1996)
[dos] command and [math] (1998)
Late on Friday.... brain fried (2002)
Problem (1997)
Grant, please help me ... (1997)
View Source from cache (1997)
suffix mapping, use of cache, etc. (1997)
Re:no [search] with NT (1997)
How does WebCatalog search the database? (1997)
locking variables? (2000)
Dreamweaver (2002)
[url] link (1998)
IE-caching (1998)
Sku numbers (1997)
Location of Webcat site in folder hierarchy (1997)
Template transformed itself into a database? (1998)