Welcome Guest, Not a member yet? Register   Sign In
My query returns empty results with big tables. Any advice?
#9

(09-15-2016, 12:39 PM)cartalot Wrote:
(09-14-2016, 04:17 PM)HeyDarling Wrote: It returns empty with like or where.
And yeah the table has a Primary index (id)

1) You also can put an index on individual fields in your database table. Makes a HUGE difference for searching. Don't put an index on all the fields, just the email field that you are searching on.

2) Do not use Like. Use Where to take full advantage of the index.
Reply


Messages In This Thread
RE: My query returns empty results with big tables. Any advice? - by Karthi Web Developer - 09-16-2016, 06:16 AM



Theme © iAndrew 2016 - Forum software by © MyBB