aspose file tools*
The moose likes Object Relational Mapping and the fly likes Database/Select Performance issue. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Database/Select Performance issue." Watch "Database/Select Performance issue." New topic
Author

Database/Select Performance issue.

Minhaj Mehmood
Ranch Hand

Joined: Jan 22, 2007
Posts: 400

Hi All,

I've a table where I store URL and It's download HTML so far there are total 8 lac rows in this table but the performance of select query is very poor. If i execute following query it takes several minutes to return result.

SELECT * FROM html_table WHERE url = "http://www.mydomain.com/mypage/"

Please let me know what should i do to prevent such issues? I've created index on url column the performance is now somehow better! but is this the viable solution? to put index on varchar type of column?


Kind Regards


SCJP6 96% | SCWCD5 81% | SCDJWS5 79%
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


Please let me know what should i do to prevent such issues? I've created index on url column the performance is now somehow better! but is this the viable solution? to put index on varchar type of column?

This is the reason indexes exist.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Database/Select Performance issue.
 
Similar Threads
Adding Indexes is causing Poor Performance
Index
Table Structure(s)
Order of SQL WHERE clause conditions & database table with index
DB structure