need suggessions !!!!
I have a problem!!
I am using HSQLDB database and i need to store files in database only.
I have many html files around 2 lacs. each file is divided in different sections which can be identified easily. i need to store these files in database.
then i need to search a word in each file and files which contain that word need to display in output.
So searching in 2lacs files in database is taking time. one suggested me to use indexing. but the problem is for searching word i need to use " like in sql query with wild cards eg: '%tight%' " . So if i do this it will again parse the entire table which is not good.
So what can i do.? tell me