We recently received this useful article/video about RAPIDLY searching a LARGE web database with Alpha Five v11 from Alpha Five developers Doron Faber and Jim Dusoe, and wanted to share it with you. I look forward to your feedback at firstname.lastname@example.org
-Richard Rabins, Alpha Software
Using Alpha Five v11, Doron and Jim (developers who specialize in Alpha,) have developed a search engine on the web that works equally well on a database of a few thousand records, as well as on a database with hundreds of millions of recordsWith Alpha Five v11 as the front end and MS SQL Server as the back end, the developers have created a powerful platform for high-performance, web-based searches.
For example, below are the search results for the name "Joe Smith." In order to limit network traffic and rendering time, the algorithms used return only the top 100 records based on values entered in the Search Options part of our interface.
We also provided the capability to enter partial address or just the street name without the street number. In the stored procedure we split the address into address number and street name on the fly for better and more accurate performance. In the address table we split the address field into two fields as Street Number and Street Name – indexing each for maximum performance.
The optimized SQL query only executes the minimum code required to identify a match. In other words, it has been designed to be intelligent enough to attempt the most likely match first, than try more “expensive” (in terms of time) queries. This helps avoid unnecessary partial searches and overhead. For a more complete explanation of the techniques used see this article at: Sql Query Optimization with Alpha Five and MS SQL Server.
The following video gives a more detailed explanation of the techniques used:
The user interface was designed using Alpha Five’s linked content feature, which allows related data to be displayed in multiple related components. This powerful capability allowed Doron and Jim to create a robust interface that would have require substantially more effort in other platforms.
About the author:Doron Farber is the owner of The Farber Consulting Group, Inc. a 20 year old IT firm which currently develops custom database applications for both web and mobile business needs. New applications are being built using Alpha Five and SQL Server. With 30 years of development experience, Doron made the decision to move all new development to the Alpha Five platform. Doron’s firm also provides database design, review, optimization and remote DBA services for MS SQL and MySQL databases.
Doron can be reached at:
- His main web site: www.dFarber.com
- Blog: www.dfarber.com/computer-consulting-blog.aspx
- Alpha Five Development : www.dfarber.com/website-design-development/alpha-five-developer.aspx
- Converting a MS Access database application to the Web: www.dfarber.com/website-design-development/convert-access-to-web.aspx