How can i set the Query Processing Time in my asp page.
i am getting this error messages "Estimated query processing time 152
exceeds limit 30"
John
7  3806 
John Peter wrote: How can i set the Query Processing Time in my asp page.
i am getting this error messages "Estimated query processing time 152
exceeds limit 30"
John
You can try increasing the CommandTimeout property of your Connection or
Command object, but I would not stop there. You should talk to your AS400
operator about building indexes on the tables involved in your query so a
better query plan will be used. This is what helped when I encountered this
error a few weeks ago.
HTH,
Bob Barrows
Bob,
i tried changing value for CommandTimeout property but still error same
message.
The field on which i have my WHERE condition is not indexed and table has
about 700000 records and i can't index the table now.
can you suggest some thing else.
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. John Peter wrote: How can i set the Query Processing Time in my asp page.
i am getting this error messages "Estimated query processing time 152
exceeds limit 30"
John You can try increasing the CommandTimeout property of your Connection or
Command object, but I would not stop there. You should talk to your AS400
operator about building indexes on the tables involved in your query so a
better query plan will be used. This is what helped when I encountered
this error a few weeks ago.
HTH,
Bob Barrows
Code:-
Set DataConnFRP = Server.CreateOb ject("ADODB.Con nection")
DataConnFRP.Con nectionTimeout = 20000
DataConnFRP.Ope n "DSN=my400;Uid= abc;Pwd=abc;"
Set ObjRSetFRP = Server.CreateOb ject("ADODB.Rec ordset")
ObjRSetFRP.Curs orLocation = 3
ObjRSetFRP.Open "Select * from FRP where Acct = 1549" , DataConnFRP
Response.Write ObjRSetFRP.Reco rdCount
ObjRSetFRP.Clos e
Set ObjRSetFRP = Nothing
DataConnFRP.Clo se
Set DataConnFRP = Nothing
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:Ov******** ******@TK2MSFTN GP09.phx.gbl... What did you change it to? Where did you change it?
Let's see some code.
John Peter wrote: Bob,
i tried changing value for CommandTimeout property but still error
same message.
The field on which i have my WHERE condition is not indexed and table
has about 700000 records and i can't index the table now.
can you suggest some thing else.
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. .. John Peter wrote:
How can i set the Query Processing Time in my asp page.
i am getting this error messages "Estimated query processing time
152 exceeds limit 30"
John
You can try increasing the CommandTimeout property of your
Connection or Command object, but I would not stop there. You should
talk to your AS400 operator about building indexes on the tables
involved in your query so a better query plan will be used. This is
what helped when I encountered this error a few weeks ago.
HTH,
Bob Barrows
I see where you set the ConnectionTimeo ut, which is totally irrelevant to
this problem. Where did you set the CommandTimeout?
Bob Barrows
John Peter wrote: Code:-
Set DataConnFRP = Server.CreateOb ject("ADODB.Con nection")
DataConnFRP.Con nectionTimeout = 20000
DataConnFRP.Ope n "DSN=my400;Uid= abc;Pwd=abc;"
Set ObjRSetFRP = Server.CreateOb ject("ADODB.Rec ordset")
ObjRSetFRP.Curs orLocation = 3
ObjRSetFRP.Open "Select * from FRP where Acct = 1549" , DataConnFRP
Response.Write ObjRSetFRP.Reco rdCount
ObjRSetFRP.Clos e
Set ObjRSetFRP = Nothing
DataConnFRP.Clo se
Set DataConnFRP = Nothing
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:Ov******** ******@TK2MSFTN GP09.phx.gbl... What did you change it to? Where did you change it?
Let's see some code.
John Peter wrote: Bob,
i tried changing value for CommandTimeout property but still error
same message.
The field on which i have my WHERE condition is not indexed and
table has about 700000 records and i can't index the table now.
can you suggest some thing else.
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
John Peter wrote:
> How can i set the Query Processing Time in my asp page.
> i am getting this error messages "Estimated query processing time
> 152 exceeds limit 30"
>
> John
You can try increasing the CommandTimeout property of your
Connection or Command object, but I would not stop there. You
should talk to your AS400 operator about building indexes on the
tables involved in your query so a better query plan will be used.
This is what helped when I encountered this error a few weeks ago.
HTH,
Bob Barrows
So where should i set the CommandTimeout and ConnectionTimeo ut?
John
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:Ow******** *******@tk2msft ngp13.phx.gbl.. . I see where you set the ConnectionTimeo ut, which is totally irrelevant to
this problem. Where did you set the CommandTimeout?
Bob Barrows
John Peter wrote: Code:-
Set DataConnFRP = Server.CreateOb ject("ADODB.Con nection")
DataConnFRP.Con nectionTimeout = 20000
DataConnFRP.Ope n "DSN=my400;Uid= abc;Pwd=abc;"
Set ObjRSetFRP = Server.CreateOb ject("ADODB.Rec ordset")
ObjRSetFRP.Curs orLocation = 3
ObjRSetFRP.Open "Select * from FRP where Acct = 1549" , DataConnFRP
Response.Write ObjRSetFRP.Reco rdCount
ObjRSetFRP.Clos e
Set ObjRSetFRP = Nothing
DataConnFRP.Clo se
Set DataConnFRP = Nothing
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:Ov******** ******@TK2MSFTN GP09.phx.gbl... What did you change it to? Where did you change it?
Let's see some code.
John Peter wrote:
Bob,
i tried changing value for CommandTimeout property but still error
same message.
The field on which i have my WHERE condition is not indexed and
table has about 700000 records and i can't index the table now.
can you suggest some thing else.
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:%2******** ********@tk2msf tngp13.phx.gbl. ..
> John Peter wrote:
>> How can i set the Query Processing Time in my asp page.
>> i am getting this error messages "Estimated query processing time
>> 152 exceeds limit 30"
>>
>> John
> You can try increasing the CommandTimeout property of your
> Connection or Command object, but I would not stop there. You
> should talk to your AS400 operator about building indexes on the
> tables involved in your query so a better query plan will be used.
> This is what helped when I encountered this error a few weeks ago.
>
> HTH,
> Bob Barrows
You shouldn't need to set ConnectionTimeo ut. Set the CommandTimeout in the
same place you set the ConnectionTimeo ut. In other words, replace
"DataConnFRP.Co nnectionTimeout = 20000" with "DataConnFRP.Co mmandTimeout =
20000" (or "DataConnFRP.Co mmandTimeout = 0" which tells it to never time
out). Again, the better thing to do is fix your query so it doesn't take so
long to execute.
HTH,
Bob Barrows
John Peter wrote: So where should i set the CommandTimeout and ConnectionTimeo ut?
John
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:Ow******** *******@tk2msft ngp13.phx.gbl.. . I see where you set the ConnectionTimeo ut, which is totally
irrelevant to this problem. Where did you set the CommandTimeout?
Bob Barrows
John Peter wrote: Code:-
Set DataConnFRP = Server.CreateOb ject("ADODB.Con nection")
DataConnFRP.Con nectionTimeout = 20000
DataConnFRP.Ope n "DSN=my400;Uid= abc;Pwd=abc;"
Set ObjRSetFRP = Server.CreateOb ject("ADODB.Rec ordset")
ObjRSetFRP.Curs orLocation = 3
ObjRSetFRP.Open "Select * from FRP where Acct = 1549" , DataConnFRP
Response.Write ObjRSetFRP.Reco rdCount
ObjRSetFRP.Clos e
Set ObjRSetFRP = Nothing
DataConnFRP.Clo se
Set DataConnFRP = Nothing
"Bob Barrows" <re*******@yaho o.com> wrote in message
news:Ov******** ******@TK2MSFTN GP09.phx.gbl...
What did you change it to? Where did you change it?
Let's see some code.
John Peter wrote:
> Bob,
> i tried changing value for CommandTimeout property but still error
> same message.
> The field on which i have my WHERE condition is not indexed and
> table has about 700000 records and i can't index the table now.
> can you suggest some thing else.
>
>
> "Bob Barrows" <re*******@yaho o.com> wrote in message
> news:%2******** ********@tk2msf tngp13.phx.gbl. ..
>> John Peter wrote:
>>> How can i set the Query Processing Time in my asp page.
>>> i am getting this error messages "Estimated query processing
>>> time 152 exceeds limit 30"
>>>
>>> John
>> You can try increasing the CommandTimeout property of your
>> Connection or Command object, but I would not stop there. You
>> should talk to your AS400 operator about building indexes on the
>> tables involved in your query so a better query plan will be
>> used. This is what helped when I encountered this error a few
>> weeks ago.
>>
>> HTH,
>> Bob Barrows
Bob,
I am just emphasizing with you.
Again, the better thing to do is fix your query so it doesn't take so
long to execute.
dlbjr
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Alex Satrapa |
last post by:
I have a table from which I'm trying to extract certain information. For
historical reasons, we archive every action on a particular thing
('thing' is identified, funnily enough, by 'id'). So the only way to
find out the current state of a particular combination of attributes is
to "select distinct on (id, ...) ... order by date desc".
In...
|
by: Passynkov, Vadim |
last post by:
I am using Asynchronous Query Processing interface from libpq library.
And I got some strange results on Solaris
My test select query is 'SELECT * from pg_user;'
and I use select system synchronous I/O multiplexer in 'C'
The first test sends 10000 select queries using 10 nonblocking connections
to database ( PQsendQuery ).
The second...
|
by: Együd Csaba |
last post by:
Hi All,
how can I improve the query performance in the following situation:
I have a big (4.5+ million rows) table. One query takes approx. 9 sec to
finish resulting ~10000 rows. But if I run simultaneously 4 similar queries
it takes nearly 5 minutes instead of 4 times 9 seconds or something near of
that.
here is a sample query:
select ...
|
by: Jeff Blee |
last post by:
I hope someone can help me get this graph outputing in proper order.
After help from Tom, I got a graph to display output from the previous
12 months and include the average of that output all in the one graph.
The output was in the order of the months, but after unioning with the
averages SQL code, the order is lost. Below is the full sql...
|
by: serge |
last post by:
How can I run a single SP by asking multiple sales question either
by using the logical operator AND for all the questions; or using
the logical operator OR for all the questions. So it's always
either AND or OR but never mixed together.
We can use Northwind database for my question, it is very similar
to the structure of the problem on the...
| | |
by: Sam |
last post by:
Hi,
I have one table like :
MyTable {field1, field2, startdate, enddate}
I want to have the count of field1 between startdate and enddate, and
the count of field2 where field2 = 1 between startdate and enddate,
all in the same query.
|
by: SaltyBoat |
last post by:
Needing to import and parse data from a large PDF file into an Access
2002 table: I start by converted the PDF file to a html file. Then
I read this html text file, line by line, into a table using a code
loop and an INSERT INTO query. About 800,000 records of raw text.
Later, I can then loop through and parse these 800,000 strings into...
|
by: dsdevonsomer |
last post by:
Hello friends,
I have one simple question. I have two tables. 1 ( Table A ) has about
2.5 million rows and second one ( Table B ) has about 1 million. There
are common ID fields in both tables. I want join them on ID field and
get all rows of Table A which are not in there Table B.
When I ran following two queries, I got same result set,...
|
by: jsacrey |
last post by:
Hey everybody, got a secnario for ya that I need a bit of help with.
Access 97 using linked tables from an SQL Server 2000 machine.
I've created a simple query using two tables joined by one field
between them. The join field in both tables are indexed and I'm
selecting 1 field from each table to lookup. The Access query is
taking more...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it. ...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
