Sorry for the wall of text, if there is a better way to show a lot of code please let me know and i'll change it in the future.
I had the following code working without xml just using jdc connect, but from what i understand its a monthly hosting cost difference of a decent sum. I'm told I need vpn as connecting using the same url as php does, didn't work. (correct me if that sounds crazy please)
This works (except insert still working that out.) But it is a lot slower then the previous setup, the ui lags while the calenders 36 boxes for the dates are being updated. takes about a second or two, long enough to notice the lag. While the other method (jbc to localhost) was practically instant. Is this to be expected or is it just my sloppy code? I'm very new so any insight would be greatly appreciated.
currently i have a separate file for years, users, month and inserting which is 4 connections 2 of which are used more then once. Perforamance wise should i compress to one file to reduce different connections and use something like i did below or keep them separate? does if effect performance.