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
|
We have a performance problem when using lightspeed model with a procedure that returns app. 35 columns and 20.000 records. It takes the procedure 20 sec. to execute and this is really worrying since we are still in development and working with a test database (which always contain less records than the production DB). We are using the model against Oracle DB. Any ideas? If we make the prcedure return less columns on the same number of records, the procedure is a lot faster. So we assume the problem lays in the mapping of all the columns which takes time. |
|
|
I understand that the post seems to be very old to reply to.. but i am using Lightspeed 3.11 with Vstudio 2010 with Oracle 10G and at Oracle the procedure takes 4 seconds to return around 18000 records.. where as using Linq
db.ProcedureName(comma seperated parameters) takes 50 seconds to return the same.. previously i was using Find method from the generated lightspeed model code.. but that also had the same problem..
any ideas???? |
|
|
Not sure what the problem might be but it might be something in the LightSpeed mapping layer (we do try to optimise away the worst aspects of sproc mapping but there are still some nasties in there). I would suggest you put a profiler on it and let us know if you see an obvious hotspot (it may be obfuscated but we can probably work it out anyway). Or post a repro and we will take a look. |
|