Hi I would just like to share my recent experience of porting a mdb supported website from mx7 to Open BlueDragon.
Access mdb's and Open BlueDragon. Yes I know this is not recommended and I would not dream of building a website now using an mdb as its database, but there are probably 1000's of existing cfml sites out there using mdb's. Its quite likely that there many of these sites are running on shared hosting packages or old versions of coldfusion and they may well end up being ported to Open BlueDragon someday. The thing that may catch people out is the fact that OpenBD does not have jdbc type 2 or type 3 drivers and that using the jdbc:odbc bridge will cause (I suspect), the datasource to process one query at a time. This can have a significant impact on a website if any of the queries take more than a couple of seconds to process. The best course of action would be to port it to another database which has a good jdbc driver but in some cases that could mean a lot of work and testing that was not expected in what should have been a simple site move, after all the site may have been perfectly happy with its mdb database before. Avoid the temptation to port it to the built in H2 database as although it allows multiple connections it will also only process one query at a time and will suffer the same issues of queries being queued up. Using cached queries can really help. If your tables are not too large then you can cache them and use 'query of queries' in place of the real tables. You will of course need to flush the cache if the underlying tables are updated by the application. If it is not possible to provide Open BlueDragon with jdbc type 2 or type 3 drivers then I would just like to highlight that this restriction exits and it is not possible to switch to the bridged connection without taking steps to deal with the lack of concurrent query processing. Hope this post is not too negative because I am very grateful to all those developers who have made Open BlueDragon worth porting to. -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon mailing list - http://groups.google.com/group/openbd?hl=en !! save a network - please trim replies before posting !!
