I was looking to display 500+ items from a database. It’s all text and consists of six columns.
I basically want to recreate something that looks like this: http://chemistry-buchwald.mit .edu/publications
(had to add a space in the link so I could post!)
Problems I’ve encountered using a database:
Using a repeater: I tried using a repeater, but the loading time crashes my browser because its 500+ items
Using a Table/List:
(1) When I try to use a table, the table ends up having an embed vertical scroll bar. is there a way to get rid of this without pagination? I would like it to be a simple large vertical page that contains all 500+ text elements.
(2) I dont know how to get it to autosize each row, seems like I can only set the height of each row in a table to a constant height and therefore will leave extra white space or cut off text.
I also don’t know how to get either of the above options to scale with the browser
Any help would be appreciated [[I’ve searched the forum posts and haven’t found much of any solutions to these problems]]. Table Master is not an option for me because I want the text to be specifically tied to my database.
Hey 
I suggest that you set the dataset to 25 items to make it load faster then add a code that loads more data when you reach the bottom of the page.
You can display as long as you can using this method.
Ahmad
Hello Ahmad,
i also gave him this idea in another of his posts, but he is searching for something like this…
https://www.test.enhancement.studio/elem-repeater
found here in this post…
https://www.wix.com/corvid/forum/community-discussion/ways-to-speed-up-a-repeater-displaying-information
And this is his first post in relation to this issue…
https://www.wix.com/corvid/forum/community-discussion/repeater-elements-are-really-slow-freeze-any-solutions
I am also interested to know how this custom element works.
Perhaps your suggestion is a good idea (i suggested the same), but from my experience, everytime you load more and more data into repeater, it becomes more and more slowly. Because of this, it is perhaps possible to load 80-100 or even 200-items (related to the size/scope of the used data in repeater), but at the latest after some amount of data, the repeater will die.
So “Quentin’s” solution is very interesting in this case.
Yes it’s better and quicker, but also require expertise to build it.
One thing that grabbed my attention while I’m reading these posts, you don’t need all the elements to be loaded on the page in order to filter them or search for values, if that’s the only reason you want that custom element, then you don’t need it, besides, the website that you refereed to is using a regular table, not a repeater, so there would be no binding, did you try the table?
What about the repeater, was it connected to a dataset or was it populated with a query?
Hi Ahmad,
I think if someone uses “Ctrl+F” to search the page using the browser i dont think the “lazy load” method where you load only 25 items at a time works does it?
It also seems to me that using a table the maximum height is 15,000 pixels, my entries will exceed 15,000 pixels.
As for the expertise to build - I’m willing to learn, or follow any examples. I sent out a request on the Wix page to bring a collaborator on to help, but no responses.
Right now, I just want a dynamic table.
I’ll also note that this is a separate element than the one that russian-dima linked to
Is this limited by the 15,000 pixel limit? I think it might be?
I have no idea if Wix pages are subject to the 15K limit, you better contact Wix Support in this regard.
You can setup an input field to search the database and display the matching results.
Here is my current site:
https://tinyurl. com/yctfreq5
Is there a way to get rid of the vertical scroll bar in embed frame? I want the only scroll bar to be the page scroll bar
There are roughly 500 entries that are each numbered, if you open the page and use the browser to search for “125” no result would show up, you have to scroll down and load all the times, then it would show up
Yes there is:
$w("#myHtmlComponent").scrolling = "no";
NOTE: This will not only hide the scroll bar, it will also disable the scrolling ability, so you can’t scroll through the iFrame.
Hmm, I am using an embed wix table, and the error I get in the code is " ‘scrolling’ does not exist on ‘#table1’", I’m a little bit of a newbie when it comes to code
You can set the table to adjust its height dynamically in the editor without code, it’ll get rid of the scrolling bar.
It is currently set to resize dynamically in the editor, but it still makes the scroll bar. I tried just about everything - I manually made it the maximum size (15,000 pixels is as big as you can go, which is not big enough so it hsa a vertical scroll bar), if i do automatic, it still creates the scroll bar - it seems like theres no way to get rid of the vertical scroll bar (i found a few other posts about this all with no solutions, but maybe i misunderstand)
Contact Wix Support to check out your editors, I don’t have access to other people’s editors. They will be able to help.
