Speaking as a programmer and MySQL DBA, additional connections are a nothing relative to everything else. Period, end of story, don't even worry about it.

Instead, you should be worrying about the following:

• Are your tables properly normalized?
• Are you using all the features provided by your RDBMS to ensure data integrity?
• Are your primary keys database-generated, meaning that your user-facing information can be easily altered? The perfect example of this is using an auto-generated id vs. the username as the primary key for your users table.

Remember - the point of a database has more to do with keeping your precious data secure from the stupid programmers who want to pollute it and less to do with the speed with which you can get answers to questions. If your data is corrupted, then you're going to get very fast answers that are wrong. Start with correctness and add speed later.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.