Performance problem in fetching record from table containg 2 million record 
Author Message
 Performance problem in fetching record from table containg 2 million record

Hi
  when I am fetching record using sequential cursor from a table
containing 2 million records  I am getting very much performance
problem.
In the begning it is very fast in milliseconds and after 15 minute it
takes 15 seconds in fetching  a record.
after 1 hour and so it is taking 1.5 minute in fetching each record.
Why it is so. What should i do to improve performance Pls help !!!!!

One more problem I am getting In BEGIN TRANSCATION command it is taking
5 minute pls help....

thanks
ramesh

Sent via Deja.com http://www.***.com/
Before you buy.



Sun, 17 Mar 2002 03:00:00 GMT
 Performance problem in fetching record from table containg 2 million record

What is your sybase version?

It may be the problem of cursor.  If you are using ASE 11.5 or above, you can try to use CASE statement to replace the cursor logic.

Quote:

> Hi
>   when I am fetching record using sequential cursor from a table
> containing 2 million records  I am getting very much performance
> problem.
> In the begning it is very fast in milliseconds and after 15 minute it
> takes 15 seconds in fetching  a record.
> after 1 hour and so it is taking 1.5 minute in fetching each record.
> Why it is so. What should i do to improve performance Pls help !!!!!
> One more problem I am getting In BEGIN TRANSCATION command it is taking
> 5 minute pls help....
> thanks
> ramesh
> Sent via Deja.com http://www.***.com/
> Before you buy.

--
- Have several nice days...
- Opinions are mine and do not necessarily reflect those of the Corp.
http://www.***.com/
http://www.{*filter*}port.com/~tangent/programming/winsock/


Sun, 17 Mar 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Fetch record into a plsql table (record.column_1 into table(index_1))

2. SQL7 server crawls (locks) when deleting records from a 3 million record table

3. IDS 7.30 : Performance of records fetched from stored procedure

4. Sql server behavior on UPDATE of Tables containing more than 3 Million records

5. 500 million records table.

6. Millions of Record in SQL Server Table

7. SQL server database table with 5 million records

8. proper way to dts 400 million record table?

9. HELP...reporting from very large table (600+ million records)

10. Add Primary Key to a 5 million record table

11. Slow self-join on a 100 million record table

12. Slow self-join on a 100 million record table


 
Powered by phpBB® Forum Software