http://qs321.pair.com?node_id=397097


in reply to Does DBI handle table alias?

The prior responses, especially VSarkiss's, are absolutely correct. You will want to verify this query from whatever commandline tools your RDBMS provides. A few thoughts on how to speed up a query:

Also, you might want to check the value of your webserver timeout. In Apache, the variable is called Timeout and is found in the httpd.conf. (I don't know about others, like IIS.) Some queries will simply take 1-2 minutes and if your timeout is set to 90 seconds (which isn't uncommon), you're going to have issues.

Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.