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 Spring in Action this week in the Spring 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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Database/Select Performance issue.