In general, to speed up the database side, you want to
- Minimize the times you connect to the database. So, you
cache connection.
- Minimize the times you compile SQL statements. So, you
use stored procedures.
- Minimize the search time to the appropriate row(s). So,
you use indices.
- Minimize the need to disk access. So, you let the database
use as much memory as possible for caching.
- Minimize the number of pages involved. So, you keep your
rows as small as possible, possibly using various tables
instead of having many columns.
Your question is very general, and without knowing the database
server, and the structure of the database, there's not much
you can say. A method that's faster on one server, could be
slower on another.
Not that any of this has anything to do with Perl.
Abigail
