Hi !
First of all, I am describing why exactly I do require help of u folks... I m coding for a really basic level search engine as my project. Now, as far as backend concerns, we have used oracle 9i. This was the first phase our project which involved designing a webcrawler which accesses web documents, parses them and removes various tags, extracts each word and assigns weight to it acording to format it has, i.e., surrounded by which tag(title, h1,h2,etc).
This info is fed into a table in oracle thru JDBC connectivity. concept of varrays is used for havin a table as column in another table. (No, nested tables were not that efficient.)
Now, We just have 3000 records in our database, but the problem is it take gooood amount of time, about 15 secs for getting results. Query processing and result generation is done thru perl-oracle connectivity. So, i need some info on threading in perl (if possible). and I must add that I'm a beginer in perl, so please be kind enough. Plus, any other suggestions are also welcomed...
Thanks in advance!
First of all, I am describing why exactly I do require help of u folks... I m coding for a really basic level search engine as my project. Now, as far as backend concerns, we have used oracle 9i. This was the first phase our project which involved designing a webcrawler which accesses web documents, parses them and removes various tags, extracts each word and assigns weight to it acording to format it has, i.e., surrounded by which tag(title, h1,h2,etc).
This info is fed into a table in oracle thru JDBC connectivity. concept of varrays is used for havin a table as column in another table. (No, nested tables were not that efficient.)
Now, We just have 3000 records in our database, but the problem is it take gooood amount of time, about 15 secs for getting results. Query processing and result generation is done thru perl-oracle connectivity. So, i need some info on threading in perl (if possible). and I must add that I'm a beginer in perl, so please be kind enough. Plus, any other suggestions are also welcomed...
Thanks in advance!