tailieunhanh - Web Publishing with PHP and FileMaker 9- P16

Web Publishing with PHP and FileMaker 9- P16:On the other hand, it would drive me nuts if you bought this book only to discover that it didn’t address your needs. In the spirit of customer satisfaction, please read the following introduction to get a sense of where I’m coming from, and whether you might get some good use out of this book. | Summary 215 Minimize Database Requests When called in to optimize a painfully slow FileMaker website I often find that the developer has inserted a call to the database inside of a foreach loop. It seems a reasonable enough thing to do but you just cannot get away with this in FileMaker. An example case might be that the developer requests a found set of products and loops through them to output the data to the browser. Then the developer decides to display some related inventory data for each product so he adds a query inside the loop to pull the inventory records for each record as the loop iterates. Naturally if you have 100 products in the found set this is going to generate 100 unnecessary requests to the database. This situation is easily optimized by adding a portal to the product layout and pulling all the data in one request and looping through the related set. Summary To claim that FileMaker is not as responsive as other database options is completely missing the point. FileMaker is not just a database it is an integrated database application development environment. The database glitterati might take offense at FileMaker s lack of separation between data and interface but it is exactly this integration that allows for incredibly short development cycles. FileMaker shines when you need new applications done yesterday. That being said there are few things more annoying than waiting for your data to load. Therefore making sure that your online application is as snappy as possible is a key concern. Following the guidelines in this section should deliver a level of performance to your users that will allow them to get their work done without wanting to burn you in effigy. A This page intentionally left blank APPENDIX B Security Concerns Introduction Securing a web application can seem a daunting task to a newbie web developer in what might seem to be a sea of experienced hackers. However you can do several simple things to ensure a reasonable level of safety.