how to search category efficiently

Hi guys,

Thanks for this forum, I downloaded and parsed ODP into mySQL database easily. The next step is to make use of it. I basicly need to know the category of a website. (enter address and return it's category)

I'm thinking to divide it into several tables according to their first letter. ex. http://aaa.bbb.cc. I'll only look for the table "a" to save the search time through whole database.

Does anyone did this before or have better idea on this? and how to do it?
I'm totally new to database. I would really appreciate if I can get good advises. Thank you very much.

I'm thinking to divide it into several tables according to their first letter. ex. http://aaa.bbb.cc. I'll only look for the table "a" to save the search time through whole database.

Click to expand...

I would never bother. Any decent database should (in efffect) be performing that task for you when it does the lookup.

Thank you for your reply.
Then I can save some work.

I use MySQL query browser to do a query, it took less than a second to retrieve the result. However, when I use java(jdbc) to retrieve the result, it took around 4 seconds, which is a lot longer.

Does anyone know what cause this and if it's possible to adjust java code to make it run faster?

Thank you very much~

How do you query the ODP?

I have downloaded the ODP dump files (content and structure) and put them in tables in MySQL with one of the php scripts described in the upload tools page.

But where do you make a query? can you query with a single term?

thanks for any help

It all depends on the website you build yourself or the tool you use to present the information from the database on your website. Just loading the data in a database will not present them on a website.