Netforest assisted the Archives Division in developing their online Historical Records index. The information is kept internally using Filemaker Pro and consisted of about 600,000 records. The challenge was to allow this information to be searched on the web with fast retrieval times. The successful solution consisted of developing a PHP module connected to a MySQL database hosted on Secretary of State's OS X web server.
Information is periodically exported from Archives Division's internal Filemaker database and then transferred into the MySQL database via FTP (File Transfer Protocol). Information is retrieved in a matter of seconds from the 600,000 records.