• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Database/Select Performance issue.

 
Minhaj Mehmood
Ranch Hand
Posts: 400
Hibernate Java Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic