sql server - Theater Seat Image (Seat Status) -

i wondering if idea store dimensions of image in db in table storing path.

or -

should better check @ run-time , put values in variable , calculate @ run-time.

or -

would better through mssql.

also better explain.

i have equation using image height, image width, row,column position seats there factor of spacing in equation come out perfectly.

hope understandable.

enzero,

hmmm, it's impossible answer question acurrately without more information; in general, it's idea keep metadata with data... , metadata can worked-out "on fly" should be, avert future headaches metadata getting out of sync.

an image size strange thing want store... it's in image-file itself, surely. format image? or missing something?

cheers. keith.

---

edit:

after bit of discussion back-and-forth, enzero says he'll try approach:

store image blob (not path file containing image) , it's height & width (etc) in seat_status table. when application starts-up load seat_status's cache, fast reference thereafter.

cheers. keith.

ps: you're welcome enzero... happy of service.