Home » U++ Library support » U++ SQL » Doubts on a sqlite query
| Re: Doubts on a sqlite query [message #38621 is a reply to message #38620] |
Sun, 30 December 2012 04:58   |
 |
forlano
Messages: 1207
Registered: March 2006
Location: Italy
|
Senior Contributor |
|
|
| dolik.rce wrote on Sat, 29 December 2012 22:40 |
That should bring it to usable speeds, my guess is under half a second 
Honza
|
Thats is two times great!
TIMING teams : 55.00 ms - 55.00 ms (55.00 ms / 1 ), min: 55.00 ms, max: 55.00 ms, nesting: 1 - 1
TIMING players-update : 168.00 ms - 168.00 ms (168.00 ms / 1 ), min: 168.00 ms, max: 168.00 ms, nesting: 1 - 1
TIMING player-select : 123.98 ms - 789.65 us (124.00 ms / 157 ), min: 0.00 ns, max: 2.00 ms, nesting: 1 - 157
Two steps and each saved 25 seconds. Not bad! 
Now I can devote my attention to the other horrible queries that still pollute my code.
Many, many thanks!
Luigi
|
|
|
|
Current Time: Tue Apr 29 00:54:25 CEST 2025
Total time taken to generate the page: 0.01575 seconds
|
Members
Pages
Help
Register
Login
Home
