I am loading data from mysql intop my web application. But it's taking a bit higher time. Is there any other method to load data faster in the application.
hi @Ankush, that's an interesting question! It's hard to say based on this why your data retrieval is slow.
Some questions that I have when reading this:
are you sure the delay is in loading the data and not in something else like calling a reactive multiple times? you could use the library profvis to see if it's the data loading
do you need to load the data realtime from the database? If not, you could first export the data to a file and read that into R. There are some packages like feather or fst that are designed to load data quickly. It also depends on your data structure, which method gives the best result.
did you do any database optimizations like creating indexes? This can speed up the select query considerable.