How expensive is doing a PRAGMA database_list? I am using the connection pooling in Apache APR's DBD system. Currently there are multiple places with in one request that does the following:
- Get a connection to the DB - Call PRAGMA database_list - Iterate through the list looking for the second database (there will be either one or two DB) - Connection to the second one if it is old (wrong physical file) or not connected. Is this very expensive? Is it worth it to do this one time at the very beginning of each request as to not do it multiple times? Normal load is 5 to 50 clients all hitting the server every 1 to 5 seconds. One hit could be multiple requests. Sam _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
