Doing my first write heavy database. What settings will help improve inserts? Only a handfull of connections, but each doing up to 30 inserts/second.Plan to have 2 to 3 clients which most of the time will not run at the same time, but ocasionaly it's possible two of them may bump into each other.
If anyone recalls a previous thread like this please suggest keywords to search on. My search on this topic came back pretty empty.