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:
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:
For those of you not on the WebCatalog Beta... (1997)
Summary search -- speed (1997)
IIS3.0 Microsoft's Fix (1998)
I'm tired of all this! (2000)
Still having problems with Authen (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
WebCat2.0 [format thousands .0f] no go (1997)
First Attempts (2000)
[WebDNA] How to get the domain name? (2009)
problems with 2 tags shakur (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
same products but different (1998)
UPDATE PROBLEM (1997)
Re:Off Topic: Frames Killer? (1998)
Running more than one WebCatalog serial# (1998)
Smart caching problems with 2.1b3? (1997)
PCS Customer submissions ? (1997)
read and write you own cookies with webcat (1997)
Item options w/ price adjustment (1997)
I try hard to think positively (1998)