CI Scalability with many user accounts in

[eluser]AlanW[/eluser]
I haven't found anything specific to configuring CI to work with many user accounts on a MySQL database. I'm finding that with only one MySQL account configured in my CI app, the app is running slowly on the hosted server. I anticipate having to create a MySQL user account for each user account in the CI app but not sure how to handle that programmatically.

Is there some documentation available?

Thanks in advance!