Member Avatar for HunainHafeez

if i have table in database(sql server) and has 1500 records and i run 2 applications(at same time) that will retrieve 500 records each so how can i do this

app1 will retrieve first 500 records
app2 will retrieve next 500 records means no over lap

SET Transaction Isolation Level Read committed not working for me

note: actually my app have one db and many client apps so (running 1 or more at a time) while reading records from DB i have to lock those rows so that it can't be read by others' requests and after that i will update status. question is how can i LOCK rows while reading ?

Edited by pritaeas because: Moved.
  • 2 Contributors
  • 2 Replies
  • 297 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by HunainHafeez
Member Avatar for pritaeas

Will you share your solution?

Member Avatar for HunainHafeez

i used Microsoft Queue for keeping cache of records as a thread in MS queue :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.