c# - Delay on first call on DataReader.Read() -
i have odp connection oracle database.
var reader = command.executereader(); whild (reader.read()) { //... }
in situations first call reader.read()
take more usual time (3 10 sectonds).
next calls ok. not next calls ok of time closing application , re-running ok too!
what parameters affect reader.read()
take time more usual?
update1: clarify situation consider situations:
- the application runs.
- lots of queries execute during application.
- user decides run report specific query tables
- execurereader called in proer time.
- now it's time read via reader. takes unusual time.
- user runs application again.
- it doesn't happen again.
i guess caching mechanism on database. if database caching executereader()
should have variant execution times.
Comments
Post a Comment