Home » RDBMS Server » Performance Tuning » how do i read new messages in cursor
how do i read new messages in cursor [message #64905] Sun, 29 February 2004 23:22
Vinod
Messages: 76
Registered: April 1999
Member
I have multi threaded program..

My one of thread is reading data from DB and putting into local buffer.

After that my others threads reading this data from buffer sending to server and after getting response they r updating the DB. After all message sent the reading thread will read new messages and put into buffer while my transmitter threads are blocked..

While sending these messages, reading thread is blocked. So I thought I will have multiple buffers but I am using the same query to read the database so I will get same messages again. Here actually I want read the messages, which are not read in previous cursor.

 



Please help me.. How do I do this?

 

pls send mail to my ID vinod_suryan@rediffmail.com

 

Thanks
Previous Topic: Limiting the number of hits to 1 with rownum.
Next Topic: Query Results not coming second time
Goto Forum:
  


Current Time: Tue Jan 19 21:21:01 CST 2021