RE: iSeries data access

Since data access over networks involve more layers than just ODBC, you
first want to have established that the bottleneck is indeed the server.
It might be that the ODBC stack on the client side is the delaying
factor, or one of the routers (and yes, it might also be the server
side).

Just thinking besides the box,

Cor

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-
bounces@xxxxxxxxxxxx] On Behalf Of Chamara Withanachchi
Sent: maandag 24 november 2008 7:23
To: RPG Programming on the AS400 / iSeries
Subject: iSeries data access

Dear All,

I'm accessing our iSeries database from web but the problem is it

takes

lot of time to access the DB some queries take more than 2 min. I'm
accessing via ODBC and those web programs coded using .NET.

Does any one know how to optimize those queries. All suggestions are
highly appreciated.



--

Thanks and Regards,

Chamara Withanachchi
Chief Executive Officer

Lanka Business Solutions Pvt Limited | CDSoft Lanka
# 90/A, Jaya Road, Udahamulla, Nugegoda, Sri Lanka.
Tel: +94 112 835416
Mob: +97 150 5698644
chamara@xxxxxxxxxxxx | cwithanachchi@xxxxxxxxx
www.360lanka.com | www.cdslk.com

Sent from my BlackBerry(r) wireless device
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.