RE: ODBC connection speed

["Walden H. Leverich III" <WaldenL@xxxxxxxxxxxxxxx>]

How big is this flat file? Is he simply dumping the file he's querying on
the iSeries or is he running some sort of extraction process that
summarizes/reduces the records that SQLServer needs to process? 

Also, how big is the SQLServer box and how loaded is the iSeries. If it's a
SQLServer box w/a Gig of memory processing a 200Meg file for one user it's
going to blow the doors off a heavily loaded iSeries processing work for
several hundred users.

Depending on his reporting needs and the load on the iSeries <flame
retardant suit on> it's not unreasonable to use a SQLServer box as a
reporting server. <flame retardant suit off>

Then again, he could simple be missing an index or two on the iSeries.

-Walden

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 

-----Original Message-----
From: Paul Nelson [mailto:pnelson@xxxxxxxxxx] 
Sent: Monday, March 17, 2003 9:15 AM
To: midrange-l@xxxxxxxxxxxx
Subject: ODBC connection speed


I have a client who does a lot of his reporting via ODBC connections (M$
bigot). When he creates a flat file and sends it to his SQL server, his
queries run very quickly. The same query definition, however, run thru ODBC
takes as much as 3 times as long. I'm waiting for him to send me an example
of the query statements so that I can examine them for the obvious culprits,
but can anybody think of anything else?

Paul Nelson
Arbor Solutions, Inc.
708-670-6978 Cell
708-923-7354 Home
pnelson@xxxxxxxxxx
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.