Basically the query is working as expected when the page index is small. I found that the performace will break down when user selects the >> (Last Page) of the...

Hi GilaMonster,

Basically I have few tables to store system data of application, and those data maybe added/updated from time to time. Thus, I have a master script to store the...

Hi Paul,

Thanks for enlighten me, I din't notice by adding the PRIMARY KEY will make so much difference.:-D

Thanks a lot, that is what I needed. 🙂

Thanks Lowell, I managed to get an idea based on your sample.

😀