• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

22. Databases > Performance Tips

Performance Tips

A web site that exists for database access should be planned around the database. First, decide what sort of load the database will have to handle, and then choose web server software and hardware based on that load. The database will probably have to do much more work than the web server, so the database will be the bottleneck.

Prepared Statements and Bind Variables

You can store a preparsed statement in the database with variables in specific positions. These variables are called “bind variables.” The performance of prepared statements is much greater than statements that must be parsed and optimized before execution, but there is overhead in setting up the statement to begin with.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint