Welcome Guest, Not a member yet? Register   Sign In
Pagination and Best way for Optimization of data load
#3

[eluser][email protected][/eluser]
[quote author="boltsabre" date="1371044332"]It really depends on what you're doing with your table. If there are "WHERE" clauses this will slow it down.
You can add indexes on appropriate columns that are involved with joins and where statements, this will help.
You can also cache results, this can also help (but you should do some testing). If/when you get a new entry into your table you just delete your cache/s and rebuild them. If you have new entries really often then you can sometimes tell the user that new entries take 5 minutes to appear and make your caches only valid for 5 minutes.

Can you be a bit more specific on what you're doing?

[/quote]

Sure, thanks for the quick respond.
For example, I will list up information that involve 100,000 records that have at least 3 or more AND conditions within a WHERE statement plus there is sorting and such functions for each columns. However, since 100,000 is a huge database records load, so we try to load them in pages of, lets say, 100 each, to reduce database connection usage. change of amount of records per page will also be provided.

By the way, I just did some research and seem Ajax JQuery PHP is the only viable solution for this huge amount of data, or the best one for any situation and optimized.

Do you think so?

Thanks!


Messages In This Thread
Pagination and Best way for Optimization of data load - by El Forum - 06-12-2013, 05:50 AM
Pagination and Best way for Optimization of data load - by El Forum - 06-12-2013, 06:38 AM
Pagination and Best way for Optimization of data load - by El Forum - 06-12-2013, 07:29 AM
Pagination and Best way for Optimization of data load - by El Forum - 06-12-2013, 08:11 AM
Pagination and Best way for Optimization of data load - by El Forum - 06-12-2013, 08:27 AM
Pagination and Best way for Optimization of data load - by El Forum - 06-12-2013, 10:57 AM
Pagination and Best way for Optimization of data load - by El Forum - 06-12-2013, 10:59 AM



Theme © iAndrew 2016 - Forum software by © MyBB