ehaerim wrote: > Thanks for all people kindly answering my questions. > > Regarding storing blobs in a separate table, > Aage => could be better because that way a page can hold more records > Milan => no need to split blobs into separate table because FB engine is > internally doing this job.
Both are valid. You need to consider how big are your blobs and how often you need to access the data. 1. If you have big blobs, it makes no sense to keep a separate table as FB would already do this for you. 2. If you have small blobs that can fit into page, then you should decide depending on the need to access them: 2.a) If you need to access blob data often, then storing it in a separate table would only slow you down because now you need to read 2+ pages instead of one. 2.b) If you need to access blob data rarely, then having a separate table would save space and you would be able to fit more records on the same amount of pages resulting in overall less pages read. If you have very small blobs compared to the record length, the benefit might not be noticeable. I always prefer having clean logic to minor performance improvement. -- Milan Babuskov ================================== The easiest way to import XML, CSV and textual files into Firebird: http://www.guacosoft.com/xmlwizard ================================== ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
