Database driven routes in CodeIgniter

[eluser]garymardell[/eluser]
Alan, the first connection is opened and then closed again in the routes hook, then a new connection will be opened for the controller, etc. This means there will only be one open at any single time. However it will effect the speed of the application slightly as it has to fetch the routes. Maybe it could cache the routes file somewhere that it gets from the database, then if you update a route, add or delete the cache file will be deleted and rebuilt on the next page load. That would decrease the impact a lot.