Re: insert update speed

[Josh B]

We might try toggling those values soon, we are first going to investigate our switch. We looked at the cpu for one of the servers that had the most connections, it was sitting basiclly idle on all 4 processor.

Yes, we do need exact row counts.

Yes, 100mbit switch at the moment.

Its also hard to run an explain on the queries since most are stored procedures. I'm coming from a MSSQL background, and havn't figured out how to get the execution plan of a stored procedure. I improvise by taking what the stored procedure would run, run just that statement and check the explain the command. We do have indexes on the most searched by columns which sould reduce the row searching, and we do paging on the database server with the limit clause, probablly not as well on a single server since each datanode has to return the queryset.