235593 Web App huge db Sphinxsearch

In Progress Posted Jul 11, 2008 Paid on delivery
In Progress Paid on delivery

Company Information database

Users search Company information database ( over 100 million and growing) and download records in a excel file.

Users are charged on downloaded records.

There is a Search with a paid data and Demo search with Demo Data.

In Paid Search, the user can buy records on "pay per download" basis or take a PrePaid Account, where the user is given various option of choosing plans with x amount of record downloads and x validity period.

The search interface ( usability design ) and speed of search are very important criteria for us.

We intend to use sphinxsearch on mysql for quick searches and ajax for a user friendly search interface.

• Subscription management – subscription plans- sign up – invoice – payment - activation

• Renewal management

• FOC keys ( promotion coupon codes)

• Email Template management

• Realtime payment integration with Paypal & CC avenue.

• Site would have huge no of auto generated Company Record Sample pages based on a Product Directory and Company directory Structure.

• SEO friendly.

• Xhtml w3c compliant

• Semantic seo css

• RSS

• XML Site maps

• Corporate web design & identity

• Robost Back End Control Panel / Admin has to have full fledged functions

• Reports- Approx 25 reports.

• Affiliate

• Reseller site

• Trouble Tickets

• Knowledge base

• Live chat like live person

• Video tutorial for search & download

• Multilingual

NOTES:

BID ONLY IF YOU UNDERSTAND THE PROJECT AND HAVE SOME EXPERIENCE IN WORKING WITH DATA INTENSIVE PROJECTS , PREFERABLY SPHINX SEARCH.

ALL BIDDERS SHOULD ANSWER THE QUESTIONS BELOW :

----------------------------------------------------------------

Hello,

To demonstrate your understanding and approach towards the project, pls answer these questions in complete details.

All bids without this answers will be disqualified.

1) Do you have any prior experience in Sphinx Search ? if yes , advise why it should be used and provide working demo url.

2) Do you have any prior experience in working on developing a web application involving a large database ? if yes provide working demo url and advise process used to make searches faster ?

3) Have you made any search interface in Ajax , if yes provide working demo url.

4) Do you have any past development experience of a robust and full fledged Control Panel ? if yes provide working demo url.

5) What kind of Excel file can be generated ? Can it be made more user friendly by adding more functionalities like a Macro Tool Bar to Sort or Search and create reports like Pivot Table etc ? Do you have any prior experience in Excel Macro programming ?

6) How do you propose that 2,000,000 pages consisting of company sample records would be generated ..would they be generated run time or will be published as static html

7) How would you auto generate meta tags, h1, h2 etc fo such pages ?

What strategy would be adopted to ensure deep crawling by such engines?

8) How would you block bulk down loaders , while allowing robots of google , yahoo and msnbot ?

9) How would you create flg Reports :

o Most Active Search Engine Keywords – contributing to Free & Paid Signups - with total amount, and no of users

o Most Active google ads – contributing to Free & Paid Signups with total amount, and no of users

o Most Active Referrers – contributing to Free & Paid Signups - with total amount, and no of users

o Most Active Internal Pages – contributing to Free & Paid Signups - with total amount, and no of users

AJAX CSS JSP MySQL Odd Jobs PHP

Project ID: #1981838

About the project

Remote project Active Jul 11, 2012