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
|
Hi I'm using lightspeed like teh DAO Layer of my solution for access to the data bas. Is it posible that it takes a lot of time to do the queries to the data base? i don't know whit but the functions that do an acces to the Data Base using the lighspeed classes take a lot get results. Any idea? thanks Ariel |
|
|
|
|
It should usually be pretty fast. Is it taking a long time at the database (e.g. inefficient SQL) or at the client? (You can get some idea of this by setting the LightSpeedContext.Logger, which captures the SQL and some basic performance info.) Can you give us an example of a query which is running slow, and a rough estimate of how long it is taking, so we can investigate please? We would also need to know: * which data provider you are using You can attach a zip file via the Options tab, or mail it to ivan @ the obvious domain if any of the info is sensitive. Thanks! |
|
|
|
