3 sql statements

Search engine database query optimization.

The search engine has mainly followin tables:

site[site_id_uniq, site_url]

page[link_id_uniq, site_id, content]

words#[word_id, link_id, weight ] where #=(0..32), there are words0 .. words32. the index tbl name is a simple hasshing as SUM(word_each_char) % 32

dict[word_id_uniq, word_text]

Need 6 sql statements with, limit, count_per_page, order by weight with/without distinct by site_id, to retrieve [url removed, login to view] by

queries providing:

a)1 word search (distinct and without distinct by site_id)

b)any words (distinct and without distinct by site_id)

c)all the words (distinct and without distinct by site_id)

The flow would be:

a) 'word' from dict get word_id ->from words[hash(word)] get link_ids ordered descending by weight, then show the links, limit, grouped, count. If word is not in

dict, use the suondex to pull closes soundex word

b) get the ids from dict, if a word from the provided set is not there use soundex. pull out link ids ordered by words weights, number of matches (how many of the words are in doc, descending by poderate weight of off the provided words)

c) as above but all the words should be in the link

The sphyder search php engine has similar database. I can provide sample database with sample data.

Beceriler: MySQL

Daha fazlasını gör: data sql, mysql search optimization, statements, Query optimization, data dict, database dict, link sql, mysql number sql, tbl, queries sql, word query sql, php count word doc, database tbl, word sql database, simple sql statements, word database sql, php word count doc, link sql database, count word doc php, tbl database, mysql sum count, pull data sql, mysql query optimization, retrieve page, search engine sql

İşveren Hakkında:
( 1 değerlendirme ) Richmond Hill, Canada

Proje NO: #4390284



Ok, This job is a piece of cake for me.

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% CAD
(0 Değerlendirme)

5 freelancers are bidding on average $48 for this job


Hi, please provide me the dump of some sample data

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(7 Değerlendirme)

IT Engineer with 13 years of experience (2000 - 2013), I have enough skills to complete this project. Please check inside my profile page - here at freelancer.com - what my former Employers have said about me. I a Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(3 Değerlendirme)

hi, with 4+ years of experience, i can assure you that i can do this job...

in %bids___i_period_sub_35% gün içinde35%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I can do it fast

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(0 Değerlendirme)