Q&A

Q1: Is it possible to use a mixture of relational database tables and flat files to store application data?
A1: Yes, it is. However, if you’re using a relational database to store any data associated with your application, I’d recommend that you store all your data there. Relational databases provide a lot of advantages over flat files for data storage.
Q2: Are there any performance issues associated with accessing relational databases from CGI scripts?
A2: Yes. Well, there’s one issue in particular that you should know about. As you know, every time a CGI program is requested, a new process is started to execute the CGI program. This means that you have to open a new database connection every time the script is called, and close the database ...

Get Sams Teach Yourself CGI in 24 Hours, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.