I have read that connection pooling helps database performance and that making seperate connection strings for reading/writing helps. The connection pooling part is obvious, but I am not sure about the multiple connection strings based on their role. Is this true? Is it better to have a connection string for reading and one for writing, another for updating - or would one connection string for my whole web app be sufficient?
Does this matter, or am I looking in the wrong places performance help?