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 andkeywords or shall I make a separte db.A [lookup] is faster than a [search]. But when I'm already displaying asearch in a db isn't it faster to get the file width & height from this samedb.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:
Shall I rather put the image size in the db in witch I have the captions andkeywords or shall I make a separte db.A [lookup] is faster than a [search]. But when I'm already displaying asearch in a db isn't it faster to get the file width & height from this samedb.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)