Context--I'm working on a web app to basically use customer criteria and learn what developers they're eligible to travel with in our system. We currently use a very complex Google Sheets file, but as the company grows we need something that's easier to maintain with multiple simultaneous users. I'm expecting 500 to 1000 searches per day.
We're comparing guest data with 10 different developers on things like age, destination, income, state of residence, marital status, even ZIP code. The different developers all have slightly different qualifications, so I need to account for a wide range of possibilities.
I'm building the code in notebooks before trying to make it an app. I'm using lists of strings, and for-loops to run the user input by qualifications looking for a match. Maybe not the most efficient approach, but it's in line with my spreadsheet experience.
I'm about halfway done with the python. My concern is, the notebook is currently taking 8 to 11 seconds to execute. Unless I'm just taking the absolute WORST approach to building this thing, that just doesn't make sense.
Will the web app execute more quickly than my python workbook, or is the execution time similar?