I have been doing some experimenting with putting FMPro database on the web using the Web Companion in 5.5 (web companion v4).

I have been getting about 30% to 50% better performance using XML to deliver the data to a Java application using a custom set of classes to deal with the XML responces compared to using the FMP JDBC driver and using java.sql classes to get at the data.

Is the FMP JDBC driver really that bad? Can anyone else comment on the performance of these two technologies?

Is there a perferred way of doing custom web publishing? I am trying to encapsulate the FMP database into a layer of my software so I can easily move to an alternate datasource in the future. So straight CDML kinds of solutions arent really what I am after. Even a PHP solution using FX.php would probably tie me to FMP as my datasource. I am looking at using JSP's and Struts to build a web application with a data source layer that hides FMP from the web app user.

Any comments would be greatly appreciated.

Bob

FP 6 might be better.

Since I