posted 17 years ago
Why dont you try displaying the merchants details with an index structure say in terms of names [A-Z having links] or mechant ids {number ranges}.
When the user clicks on any of the link, it will inturn display the set of merchants falling under that category with a pagination if the number of users are more.
To be more clear:,
Case 1: Merchants with the name:
In the main or first page where the merchant details will have to be shown, lets say, you have some 'n' alphabets matching for the starting name of available merchants, whereas each alphabet having a link to proceed further by displaying the details of the merchants whose name starts with the selected/clicked alphabet.
Page 1 :
Lets say, all your 4000 merchants names are starting with A,B,C,F,J,K and not anything else (for example), you will have these alphabets with links in the first page.
Page 2 :
When the user clicks on the alphabet 'A', and if in case the merchants count is say about 1600 for this category, you display the portion of merchants details (say merchant id and name in full) upto the allowed limit. For example, 20 merchants per page would be decent on an average. This page will then contain the links for pagination for all the set of merchants whose name starts with the alphabet 'A'.
Page 3:
This page will show the complete information of the particular merchant whose name was selected in Page 2. This can even be a pop-up window as rathi told earlier.
Case 2: Merchants with the Id
Same as Case 1 but the front page will have the pagination links with the merchants id range instead of names. Say, 1-1000, 1001-2000 etc. Then you can have the subsequent logic for proceeding further in displaying the merchant details.
Hope this helps to certain extent.