BR SQL performance tweaking
Posted: Fri Jun 02, 2017 1:47 pm
Hi everyone. I've been experimenting with BR SQL features, and got everything working, but performance comparison between BR and SQL is turning out almost 50 times faster in favor of BR.
BR WRITE 120,000 records takes 3 seconds
SQL INSERT 120,000 rows takes 125 seconds
Things are even worse when it comes to SQL SELECT and UPDATE.
At first I used the "SQL Server" driver, but realized this is outdated and switched to using "SQL Server Native Client 11.0" driver which is latest. However, this did NOT boost performance
My question is: how can we optimize doing lots of INSERT, SELECT, UPDATE queries?
BR WRITE 120,000 records takes 3 seconds
SQL INSERT 120,000 rows takes 125 seconds
Things are even worse when it comes to SQL SELECT and UPDATE.
At first I used the "SQL Server" driver, but realized this is outdated and switched to using "SQL Server Native Client 11.0" driver which is latest. However, this did NOT boost performance
My question is: how can we optimize doing lots of INSERT, SELECT, UPDATE queries?