Subsonic linq using activerecord very slow compared to simplerepository
- by skiik
Anyone know anything about why linq queries are about 6 times slower when querying using active record vs simplerepository?
The below code runs 6 times slower than when i query the data using a simple repository. This code is executed 1000 times in a loop
Thanks in advance
string ret = "";
// if (plan == null)
{
plan =VOUCHER_PLAN.SingleOrDefault(x => x.TENDER_TYPE == tenderType);
}
if (plan == null)
throw new InvalidOperationException("voucher type does not exist." + tenderType);
seq = plan.VOUCHER_SEQUENCES.First();
int i = seq.CURRENT_NUMBER;
seq.CURRENT_NUMBER += seq.STEP;
seq.Save();
