Timeout when data is larger than normal

[trangv2306]

Hello,

Loving svelte-headless-table so far. Thank you for the amazing work!

I have some issues that would love to hear everyone solution to overcome this.

I'm working with a web app to deal with fairly large database tables. One that I'm working on right now has almost 4000 rows of data. I don't think it's VERY big, but it's for sure larger than normal.

I'm using Prisma to query all of the rows, then return to the view. The server gives back the data fairly fast (I ran a console log to check when the call is done). However, when the table is being built with such large amount of data, it constantly timeouts. If I give it another 3 mins or so, it would finish correct. Maybe because I have sort. filter and also pagination plugins applied, so it takes time for the plugin to build the table.

No errors in between besides the site timing out.

Do you guys have any solution? Like fetching patchs of data etc. ? But would it still time out after the data grows to the same amount? Or is there a fix that I can add?

I'm new to svelte so open to suggestion if any of you have experience using this with large databases. I would love to learn the best way to approach this.

Thank you!