Hi all,
Being new to Active4D, I want to check that my strategy for placing a directory online makes sense before starting to work out how to code it up.
I have 4D Server 2003 serving data to 4D Clients on our office network. We have about a dozen related tables full of information about airports, aircraft types, aircraft owners and related companies. Once a year we export this using the XTags plug-in for QuarkXPress and print it as a book.
Now I want to put the directory online, and plan to use Active4D in conjunction with the 4D Web Server.
The data is quite complex. For example, for each airport I need to display data from an [Airports] table, but also look up related records in three other tables and display these underneath. There will be individual pages like this for 1,000 airports, 1,000 air charter companies, 300 maintenance companies and 100 aircraft types.
So, is it best to reduce the load on my 4D Server by running a daily method to create static HTML pages which can served by WebSTAR for each airport, charter, maintenance and aircraft type?
On the other hand, only a proportion of these pages will have changed, or indeed be viewed in any given day. So is it better to simply serve it all up dynamically on request?
If the former is preferable, then what is the best strategy to achieve this with Active4D?
Any
