controlling repeater

i have a repeater that connects to a large database and i dont want that every time
that i open this page it will fill with all the fields in the database.
this page is a search page and i want the repeater to be shown only after the search
function is starts.
the reason is that it’s make the page load very slow and if i try using collapse on the repeater
the page will still load slow.

With the repeater you can set manually how many it shows on your page in it’s settings. However even that and having it collapsed/hidden on load until the user enters an input to search for and then it shows the filtered result, it will still take a while to load your large dataset.

If it is the issue with the large database taking a while to load up in the first place, then simply think about splitting it into different datasets so that it is lots of small datasets rather than just one large one.

This is what i did in the beginning but it still took lot of time to load…
is there any why to present database except repeater ?