RE: ODBC connection speed

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.