Sybase polling performance impact

We have a Sybase ASE simple table, with one column, like below

Table Name: Items

+------------+

| itemId |

+------------+

| ABCDEFGH1 |

| ABCDEFGH2 |

+------------+

itemId is the primary key.

A producer would populate this table with data at an undeterministic rate.

We have a consumer (Java process) which polls this table constantly (using JDBC), by doing

SELECT TOP 5000 itemId FROM Items ORDER BY itemId desc

And these itemIds will be deleted by the consumer a bit later after successful processing (say every 200ms).

We can assume that the consumer is ALWAYS faster than producer, which...

Read More »

By: StackOverFlow - Saturday, 16 June

Related Posts