[AngularJS] Re: data persistence
Hi Vishal, The size of the pages of your request and the side of the pages on the UI doesn't need to be in sync. There is no issue in caching a couple of thousands of rows in your frontend services. it takes some planning and calculation. for example, if you keep 10 pages of data in the buffer, you might want to get the next batch when you are hitting page 8 or 9. Regards Sander -- You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group. To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/angular/6ce84ecf-b529-4817-a5bf-0dec9f5c9208%40googlegroups.com.
[AngularJS] Re: data persistence
I would go with redis caching. https://redis.io/topics/introduction -- You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group. To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/angular/99bf5efd-8cc3-4526-99ef-8df8b9c527cc%40googlegroups.com.
[AngularJS] Re: data persistence
There are no wildcard searches. The search is based on selecting proper values from over 12 dropdown list. Sql Server is the database. I dont really have an issue except that i dont like current approach of hitting database for every 10 records. I want to be able to hold 1000+ records in memory and show those spread in 100 pages - 10 records per page. and if user wants to see more, then again hit the database to get another/next 1000 records. Front end is Angular, which is calling .Net Rest APIs. These APIs connect to SQL via Entity Framework 6. On Thursday, 8 August 2019 00:19:41 UTC+5:30, Tito wrote: > > Answer this first. > 1. Are you doing any wild card searches. > 2. What backend is it? > > Your issue most probably is not angular. Sounds like backend issue > -- You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group. To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/angular/a445d113-5a4b-4d7e-9566-ba81baea9a11%40googlegroups.com.
[AngularJS] Re: data persistence
Answer this first. 1. Are you doing any wild card searches. 2. What backend is it? Your issue most probably is not angular. Sounds like backend issue -- You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group. To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/angular/c6afd964-debd-4951-babd-1680d7d21d9a%40googlegroups.com.
[AngularJS] Re: data persistence
Its a search based on parameters selected by the user. There are about 10 parameters. Not all searches lead to 2 million but worse case scenarios does. It uses restful API to pull records based on offset so it fetches only 10 records at a time based on page user is on and if user has clicked next or previous. Problem is hitting database on every 10 records. I would like to get about 1000 records at a time and then cache them locally somehow so I can use those to traverse thru those records without hitting the database. In return, this would substantially reduce the database calls. As I am new to Angular, I am not aware of possible features that can help me to implement my idea. Pls suggest if you can think of something. Thanks On Wednesday, 7 August 2019 17:37:14 UTC+5:30, Tito wrote: > > Out of the 2 million records which ones are pertinent to the user? > What kind of searches are you doing? Wildcard ```like '%search term%' > > -- You received this message because you are subscribed to the Google Groups "Angular and AngularJS discussion" group. To unsubscribe from this group and stop receiving emails from it, send an email to angular+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/angular/fda0cff6-2614-4e2c-9bde-077cb6730489%40googlegroups.com.