comp730:MeAndYou Project Implementation

1. Introduction
Overview of the chosen implementation, software choices and recommendations for future upgrades or changes.

2. Summary

 * Windows Server 2008 on virtual machine
 * lamp.unh.edu
 * XAMPP v3.2.3
 * Database: MySQL


 * Search program (Spring 2017)
 * Using C# .NET Framework 4.
 * Program compiled outside of system and loaded to Software directory
 * Files kept in C:\Software\Programs
 * Using Task Scheduler to loop batch file


 * Webpage
 * C:\xampp\htdocs
 * Software storage and control
 * SVN


 * Search program (Spring 2016)
 * Using Java JDK1.8.0_77
 * Program compiled outside of system and loaded to Software directory
 * Files kept in C:\Software
 * Using Task Scheduler to loop batch file

3. Recommendations

 * Move implementation to Linux server
 * Windows Server currently limited to two users
 * Server is very not responsive for logged in users
 * Database testing showed speed improvement on Linux
 * XAMPP, MySQL, Java and webpage files compatible
 * Considered C++ for search program
 * Compile executable
 * Scale issues
 * Create join table inside of DB
 * Extract data in chunks by timestamp set by entry or edit
 * Use hashing techniques
 * Use SQL LIKE and regex capabilities
 * Create SQL near match functions
 * Use Mutlithreading to allow parallel searches.