I’m in the process of converting a prototype 😉 booking system that I built 8 years ago in a database scripting language ( Lotus Approach ).
Obviously, the time has come to code The Real Thing !!!
The original application accesses the local database to produce a dropdown list with about 3500 entries. It has a typeahead function, and the response time is very acceptable.
The question: What would be the best way to do this with my new setup?
I am using Linux, Apache and PHP (+Smarty) / Mysql on the server with Javascript on the client.
What would be the best way of coding this functionality, given a web-based architecture, on a local network? Although I have not measured this yet, I am concerned about response time. I imagine that I would need to code the dropdown in Javascript, but am hoping for input from others on this. What other ways are there of doing this?
The data of the dropdown list is somewhat dynamic, so it is not sufficient to place a one-time copy on the client, although it does not change very actively.
I appreciate any thoughts, and hope the cross-application question is not offensive!
Steve