jquery check if username already in database using ajax

Question

Every time when someone types something in the inputfield, I use ajax to check if the username already exists. But this query is very slow. I uploaded the page and it need 2-5s for this query. I use this code here

$('#register_username').bind('input propertychange', function() {
    $.ajax({
        type: "POST",
        url: "check_username.php",
        data: "username="+value
        success: function(response){
           //...
        }
    }
}

In check_username.php is only a sql statement. Im using a free webspace at the moment (lima-city.de). Is that the problem maybe?

You can test it here, enter in the first inputfield Benutzername

possible duplicate of Check if username exists in database with AJAX — Lumi Lu
– Lumi Lu, Commented Jun 6, 2015 at 21:02
We do not know your query and your db structure. So we cannot tell you why it is slow. Maybe an index for your database field should help. But who knows without knowing your db structure. — steven
– steven, Commented Jun 6, 2015 at 21:07
"But this query is very slow." - so, what does your question have to do with jQuery? How do we know your DB isn't properly indexed? we also don't know how your code is setup for your query. — Funk Forty Niner
– Funk Forty Niner, Commented Jun 6, 2015 at 21:19

Death-is-the-real-truth · Accepted Answer · 2015-06-06 21:34:06Z

1

Try to do on focusout like below, and check once:-

$(document).bind('focusout','#register_username', function() {
    $.ajax({
        type: "POST",
        url: "check_username.php",
        data: "username="+value
        success: function(response){
           //...
        }
    }
}

Note:- Not only this it will depend on your query code also, that how much efficient it is. that means it will be optimized to give result in minimum amount of time. May be some problem is there also.I am not sure about that

edited Jun 6, 2015 at 21:34

answered Jun 6, 2015 at 21:17

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nikhil Aggarwal · Accepted Answer · 2015-06-06 21:07:05Z

1

You can bind the blur event. It will send the query only once you loose focus of the input field.

answered Jun 6, 2015 at 21:07

Nikhil Aggarwal

28.5k4 gold badges46 silver badges61 bronze badges

Collectives™ on Stack Overflow

jquery check if username already in database using ajax

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related