Welcome Guest, Not a member yet? Register   Sign In
Problem with large records
#6

@Germanikus,
You might want to check your query because it should not take that long to pull that many records. Also, check to make sure that your table has a proper index. If you are able to...run your query with EXPLAIN (https://dev.mysql.com/doc/refman/5.7/en/explain.html ). This will help you figure out if your query is efficient. I'm assuming that you are using MySQL.
Reply


Messages In This Thread
Problem with large records - by Germanikus - 09-21-2017, 09:57 PM
RE: Problem with large records - by Wouter60 - 09-22-2017, 12:11 AM
RE: Problem with large records - by Abhi - 09-22-2017, 12:21 AM
RE: Problem with large records - by Germanikus - 09-22-2017, 02:17 AM
RE: Problem with large records - by rtenny - 09-22-2017, 03:26 AM
RE: Problem with large records - by php_rocs - 09-22-2017, 02:55 PM



Theme © iAndrew 2016 - Forum software by © MyBB