Home » U++ Library support » U++ SQL » Doubts on a sqlite query
Re: Doubts on a sqlite query [message #38616 is a reply to message #38615] |
Sat, 29 December 2012 15:35 |
|
forlano
Messages: 1185 Registered: March 2006 Location: Italy
|
Senior Contributor |
|
|
Quote: | It actually seems to me that players-update is the best performing one out of those three
|
This shows how deep is my understanding of the subject
Quote: | It should lower the query count to 157+157+1. I'm really curious if it cuts down the overall time significantly or not
|
You are welcome. I've just copied and paste to get
TIMING teams : 0.00 ns - 0.00 ns ( 0.00 ns / 1 ), min: 0.00 ns, max: 0.00 ns, nesting: 1 - 1
TIMING players-update : 9.97 ms - 63.51 us (10.00 ms / 157 ), min: 0.00 ns, max: 1.00 ms, nesting: 1 - 157
TIMING player-select : 29.97 ms - 190.90 us (30.00 ms / 157 ), min: 0.00 ns, max: 1.00 ms, nesting: 1 - 157
Now it takes an instant instead of 46 seconds
I discovered there is another bottleneck in my code. I am going to remove with your excellent tecnique!
Thanks a lot and Happy New Year!!!
Luigi
Edit: just now I checked better and I discovered that the query do nothing ... there should be some syntax error in the query somewhere... investigating
[Updated on: Sat, 29 December 2012 16:56] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Mon May 06 15:30:22 CEST 2024
Total time taken to generate the page: 0.01643 seconds
|