Review my PHP / JS / mySQL live search drop down and improve efficiency

£10-20 GBP

Închis

Data postării:

circa 4 ani în urmă

£10-20 GBP

Plata la predare

I have a page on my website that is used to search a database of around 5000-6000 items. It searches 2 fields and returns any matches that contain anything in either field. I have been told it is not very well optimised by the site hosting, and I need to determine if it is a real issue that I have with my code, or if it's an issue with the site hosting. 99% of the time the query seems to work fine as expected but I am having downtime supposedly because of this functionality. I am looking for someone that can provide the same functionality in a more efficient way. I don't know if searching directly in the database is the best way to do this, or if the query / database settings could be amended to be more efficient. I'd also like to know if it is actually causing a problem, or if it's an excuse from the hosting company.

Software Architecture

ID-ul proiectului: 24791607

Despre proiect

5 propuneri

Proiect la distanță

Activ: 4 ani în urmă

Vrei să câștigi bani?

Adresa de e-mail

Avantajele de a licita pe platforma Freelancer

Stabilește bugetul și intervalul temporal

Îți primești plata pentru serviciile prestate

Evidențiază-ți propunerea

Te înregistrezi și licitezi gratuit pentru proiecte

5 freelanceri plasează o ofertă medie de £19 GBP pentru proiect

@searchtechnow

Can i see the piece of code using which you are getting and printing the records? Getting the records doesn't take time but the printing and showing the record can take time.

£15 GBP în 7 zile

4,8

(444 recenzii)

8,6

@shanymathew

Hello Sir am an expert php and mysql developer i can do this search more efficiently please reply wish to work for you Thank YOU

£25 GBP în 1 zi

5,0

(69 recenzii)

5,5

@umairmalik10

Hi, I've read your description of issue and I can review and optimize the query or Db structure to it's best possible limit. Please send me a message so that we can discuss in detail thanks.

£30 GBP în 2 zile