comment on

When speaking about placeholders, you may want to look at Tricks with DBI. I liked it and learned a lot. Also, you may want to look at discussion about Learning CGI & DBI well - if this is what you want to learn well... ;-)

And yes, INDEX is a way how to increase speed of data access in database - for the price: you have some speed penalty to maintan it when updating indexed fields. This is interesting, but OT here.

pmas
To make errors is human. But to make million errors per second, you need a computer.

In reply to Re: Optimizing a MySQL Query by pmas
in thread Optimizing a MySQL Query by mandrakus

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or or How to display code and escape characters are good places to start.


Clear questions and runnable code get the best and fastest answer
	PerlMonks