This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
When I use SaveChanges to a MySQL db across the web it takes about 2 seconds.. Where as when I run the the same INSERT SQL using the query window outside of lightspeed it takes under 100ms Whats going on here? |
|
|
|
|
What is strange is that the sql is running quite quickly.. --> Time: 112 ms
So what is the other 1.5 seconds for? |
|
|
|
|
What is strange is that the SQL is executing quite quickly.. --> Time: 112 ms So what is taking the other 1.5 seconds?
|
|
|
|
|
That sounds a bit strange. How many items are you saving? Can you reproduce this in a simple console project that you could post here? Thanks! |
|
|
|
|
Just a single item..
Ill get a console app ready |
|
|
|
