Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Does DBI handle table alias?

by punch_card_don (Curate)
on Oct 06, 2004 at 19:54 UTC ( #397151=note: print w/replies, xml ) Need Help??


in reply to Does DBI handle table alias?

OK - this is going to be an interesting experiment. I'm in the process of adding indeices. I'm going to add different combinations of different kinds of indices and test each one. Will keep this topic posted.

Replies are listed 'Best First'.
Re^2: Does DBI handle table alias?
by The_Rabbit (Acolyte) on Oct 06, 2004 at 21:10 UTC
    Be careful... you really don't want to create anymore indexes than necessary. Even though you might see a performance increase in your test by building a bunch of extra indexes you might end up causing performance problems in other parts of the system. Remember, that whenever a rows are inserted or deleted there is an additional work that has to be for each index. Just like everything else in programming you have to strike a balance.

    Looking at the query you had problems with I am guessing that the only indexes that are going to help are to build an index for user_id and characteristic_id for both tables. Generally, columns that appear in join conditions are good candidates for building an index.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://397151]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2022-08-07 20:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?