阅读背景:

使用数据库表作为队列

来源:互联网 

I want to use a database table as a queue. I want to insert in it and take elements from it in the inserted order (FIFO). My main consideration is performance because I have thousands of these transactions each second. So I want to use a SQL query that gives me the first element without searching the whole table. I do not remove a row when I read it. Does SELECT TOP 1 ..... help here? Should I use any special indexes?I want to use a database table as a queue. I wa




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: