Choosing Your Scripting Platform

As with all development topics, there is a trade-off to be made between using client-side database features and server-side database features. If you go with server-side recordsets, you get faster processing when the page is first loaded but you have to take round-trips to the server each time you need to carry out some action on the data. If you go with client-side recordsets, you often get a slower download but faster response time when working with your data on the page. Using the Scripting Object Model does involve some overhead in terms of additional files that need to be processed. Therefore, if you want to squeeze the most out of your applications, you might even want to forgo the Scripting Object Model entirely, which means doing without design-time controls. The trade-off is speed of development versus speed of execution.