I have a union query running on an OnChange Event - Bad Idea?

[trb5016]

Hey Guys, I'd like your opinions.

I have a multi user (~5 simultaneous) access front end/SQL backend (each user has local copy)

For one search I have a Union query running as the user types. This is bringing some slight lag as the query refreshes from a user typing. (unlike similar search forms that use a simpler query)

It's not a big deal, but do you think this could cause some strain issues with the DB?

Query below:

    SQL = "SELECT Phone.ID_Phone, [Room Dropdown].Room, Phone.txt_Telephone " & _
          "FROM Phone INNER JOIN (Room_Jacks INNER JOIN [Room Dropdown] ON Room_Jacks.ID_Room = [Room Dropdown].ID_Room) ON Phone.txt_Jack = Room_Jacks.[txt_Jack Number] " & _
          "WHERE Room Like '*" & RoomName & "*' " & _
          "UNION ALL " & _
          "SELECT Satellites.ID_Phone, [Room Dropdown].Room, Phone.txt_Telephone " & _
          "FROM (Satellites INNER JOIN [Room Dropdown] ON Satellites.ID_Room = [Room Dropdown].ID_Room) INNER JOIN Phone ON Satellites.ID_Phone = Phone.ID_Phone " & _
          "WHERE Room Like '*" & RoomName & "*'" & _
          "ORDER BY 2"

[pbaldy]

It will obviously cause some load, but if that's what the situation requires, then go for it. If the circumstances warrant it, you could test for the length of the input text and not set the SQL until it was at least x characters.