[firebird-support] DB w/ 16kb page site and BLOB fields size w/ content just 40bytes by record
Dear friends, my question is: The components cxScheduler (from DevExpress.com ) use some fields type BLOB! One field, type RESOURCE_DATA_INFO (devexpress), use just 40bytes for store your information about data resources of the record. My question is, How many bytes are store/or used/ in a DB with page site of 16kb and one field BLOB (binary = numbers) in this case, where DevExpress use just 40bytes/record? Example: If I have 1.000.000 records in my Scheduler and using the field (BLOB binary = numbers save for cxScheduler / DevExpress) that use just 40bytes / records? So, will be: 1.000.000 x 40bytesOR 1.000.000 x 16kbytes (pages size) What is the size occuped in disk? Will be the size page just a possible space to be occupied, or even if you do not occupy the whole space, the rest would be busy with something, such as blanks, etc ...? Here the link to fields definition of cxScheduler by DevExpress: http://www.devexpress.com/Support/Center/Question/Details/A2352
[firebird-support] Thanks For All! But, but still not what I need to solve!
I am awaiting a new suggestions! Regards to all
[firebird-support] Delphi + Firebird + BLOB + MSWord document + Stream
Dear friends, I would like to know, if its possible, a help of you! I need to know how to save one file MS Word Doc or Docx in a BLOB and read it by stream, but, dont to use save in disk before! I search in internet for a long time, but, only found the same procedure... Can you help me? Scenary: -- Delphi xe2 -- Firebird 2.5 -- FIBPLus 7.3 -- Windows 7 I know how to save the file (doc. jpg, etc...) in a BLOB field (binary type) I know how to read (using save in disk and read the file) But, I need read the BLOB content by STREAM, or be, read portions of file into BLOB Thanks for you! Note: If you can not help me, please if you can show me Some site or user who can give me a hint about this problem!
