Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xpwill
Starting Member
2 Posts |
 Posted - 2008-05-11 : 18:14:58
|
I am making webistes for my customers. mostly easy standard stuff that I can do with static pages, php or in odd cases some sort of cms. this time I have gotten a big challange that i am not sure how to attack. Mainly because I am not a database wizard.The client ask for a DB generated site, and here several open-sorce cms's fits the bill. The project is sort of a directory-listing site. Where you can search for diffenrent companies in your erea. I belive the DB will contain 1.5-2 millions companies. And the one that pays premium will get listed first.1:) I am thinking that geography and type of business will be to ways of finding what you need, but what if you type in ie "burger kind" rather then burger king. How can I make the module also find similarities? The module can not find only correct spelled names, must also find similarities. Is there any way that SQL can handle this or must it be hardcoded into a code-behind? If I use the full-text searching options will that slow down searches and give me performance penalties?2:) When a visitor makes a search for a company or type of business how can I make the premium customer show up first and the ones that pay less or nothing shows up further back? Sort of reserve the first page or pages for paying customers? 3:) Is there any cms or cms-modules out there that can fix this for me, free or for sale? do you know people whom have allready made a site like this?4:) For me this database seems rather large, so how do I make sure to get good performance?5:) Any thoughts on other importent ways that visitors can search for listings will be great. I am in deep water here and are grasping for straws, pls keep me from drawning -will |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-05-12 : 01:48:06
|
| 1) Look at SOUNDEX.2) You would need to create a bit field (or similar) to indicate that they are premium customers, set the premiums to 1, then order the results desc.3) I do not know, but I am sure there are. Any directory site will be like this.4) The database is not large, but some indexes on the table would help as this would be mainly a search table. |
 |
|
|
xpwill
Starting Member
2 Posts |
Posted - 2008-05-12 : 05:04:22
|
quote:
Originally posted by RickD
1) Look at SOUNDEX.4) The database is not large, but some indexes on the table would help as this would be mainly a search table.
Thank you for the help 1:) I did check the soundex and also read up on metaphone/double-metaphone.This approach will work very well for sites in english with english content, yes. But how will it work for sites with german language, does it even excist soundex for german or have I got the whole point wrong here?4:) Not sure I understand you here: quote:
some indexes on the table...
thx-will |
|
|
|
|
|
|
|
|
Searchengine for database?