Web Development
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
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.
This discussion is closed to new replies.
Sort by Trending