> 1. Store scripts as file (sql or txt); > 2. Store scripts in blob file, in separate db (fdb, xml, access > mdb, etc); > 3. Directly in code (not ok , I will delivery regular updates and > new scripts)
You should make this decision yourself because it's your system. We prefer xml files for such tasks. > How to execute scripts for best performance? Using FbScript, > FBatchExecution or executing blocks? I think EXECUTE BLOCK will show best performance because in this case all script called as single sql command... ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
