• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC with Full Text Search?

 
Leonardo Carreira
Ranch Hand
Posts: 489
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Friends..

i have a question..
i use Swing application + JDBC + MySQL v5.0.81..

is it possible to put Full Text Search for my application?..
if its possible, what is the best tool that i have to use?
How about Sphinx?..
or is there any Full Text Search tool which could be ran with jdbc together?..

Thanks in advance
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That depends on what, exactly, you mean by "full text search". SQL can find any text within varchar fields using the "... like '%searchstring%' ... " syntax.
 
Leonardo Carreira
Ranch Hand
Posts: 489
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks @Ulf for your reply..

sincerely, i really doubt.. when is the best way to use Full Text Search?..
if i use Full Text Search like Sphinx, is performance of my query is better than before?..

Thanks..
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So you have text search now? How does it work, and why do you want to change it? Just for performance reasons?
 
Leonardo Carreira
Ranch Hand
Posts: 489
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i just want to try to know comparison both of them..


 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How can we compare two things if we only know one of them?
 
Leonardo Carreira
Ranch Hand
Posts: 489
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
yeah.. exactly we can't compare both of them..

okay, i will keep using PreparedStatement..
Thanks in advance...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic