Re: Speeding Up Queries with LINQ -- SYSTEMIDOTNET

Subject: Re: Speeding Up Queries with LINQ
From: Mike <koldark@xxxxxxxxx>
Date: Thu, 11 Mar 2010 10:51:35 -0600
List-archive: <http://archive.midrange.com/systemidotnet>
List-help: <mailto:systemidotnet-request@midrange.com?subject=help>
List-id: ".net use with the System i" <systemidotnet.midrange.com>
List-post: <mailto:systemidotnet@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/systemidotnet>, <mailto:systemidotnet-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/systemidotnet>, <mailto:systemidotnet-request@midrange.com?subject=unsubscribe>

An update to this.

It appears like the database was poorly designed. Whatever LINQ was
generating in the background it was highly inefficient code. I am not saying
the LINQ is bad, it just was bad for this database. I converted to a quickly
thrown together .XSD setup and the processing time went from 1.25 minutes to
15 seconds. Once I do a proper redesign, I can only guess I'll shave a few
more seconds off of that. I'll try LINQ again some other day on a better
database.

--
Mike Wills
http://mikewills.info
P: (507) 933-0880 | Skype: koldark

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Speeding Up Queries with LINQ , Walden H. Leverich

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.