General discussion

Locked

SQL Query Performance

By manivbizap ·
How can increase the sql query performance
am using two table with inner join of primary key and unique key with where clause of unique key... fetching 1200 rows 300 milli seconds... how to increase

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Can't tell from here can we.

by Tony Hopkinson In reply to SQL Query Performance

The query would have been good, the datatypes of the fields used in the join and the where.

What DBMS it is would be a useful clue as well.

There are so many things that could affect percieved performance it's impossible to say. Some optimisations will adversely impact other requirements, other may be an increase inm complexity or a reduction in data integrity.

So bit more info. This sort of thing can end up being far from simple unless you've done something a bit daft.

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums