faster machine, but slower results...

6 views
Skip to first unread message

Matthijs de Z

unread,
Jan 18, 2011, 6:54:49 AM1/18/11
to DbLinq
Hi,

I used to run a C# project on a
(machine A)
Dell Precision T3400
intel Core 2 Duo E6750 @ 2.66GHz, 3.25GB of RAM running XP
professional version 2002 service pack 3 32 bit.

Now I have a new machine.
(machine B)
Dell T5500
Intel Xeon CPU X5570 @2.93GHz, 3.18 RAM running XP professional
version 2002 SP3 also 32 bit.

Both machines have all the .net versions installed (from 2 up to 4)

On machine A I used Visual Studio express 2010.
On machine B I use visual studio ultimate edition 2010.

The solution is exactly the same and I use DBLinq 0.19.0.0.

But here's th catch. When I retrieve data from the DB on machine A,
it's about 190 ms, on machine B it's about 600 ms...
First I thought it might be a network problem, so I installed a mysql
database locally and tried it again. Same result...

This is the way I do it:

IEnumerable<Quotes> myQuotes = from quotes in _db.Quotes
where quotes.TickerID == 5
orderby quotes.DbdAte
ascending
select quotes;

When retrieving the same dataset within SQLYog, it just a couple of ms
(between 0 and 16).
Where should I look for the problem? everything else is working fine
and faster on machine B than on machine A.
I just don't get it...
Regards,

Matthijs




Reply all
Reply to author
Forward
0 new messages