Hi, bit of a frontend question, I use Apollo Clien...
# orm-help
j
Hi, bit of a frontend question, I use Apollo Client and on my UI I have 3 tabs: Contacts, Leads, and All. Clicking Contacts or Leads is easy, using Nexus I can easily paginate and search these 2 tables. My real challenge is the 3rd tab, which should show both Leads and Contacts all in 1 table. How would you recommend I solve this? Would you use a MySQL VIEW, or use 2 query hooks, or what? And would you idea work with pagination? offset based, or cursor too?
n
Hey James 👋 Are your queries taking a long time to return data? In your third tab if you are fetching data from both tables and if it’s taking too much time then I would suggest you to check if there are proper indexes in place. And based on your UI you could definitely use pagination to restrict the data which is visible