Completed

Spatial index + rectangle search in MySQL database - open to bidding

Hi,

I hope that you take this challenge :)

I need experienced programmer for solve this problem and which can move us forward.

The videoscreen from our page [url removed, login to view] and you will see the proces off loading the results... you can try by yourself if you want on live page... the new results must be much faster. now on site is turn off cache + other compress function which support better loading of content.... the changes will in mysql databses, the page only ilustrate speed which is critical slow (or searching POi one geo)

[url removed, login to view]

A. - list all queries with geographical data

B. - "replicate" (but dont move !!!) all geographical data to one table with geographical data and implement stored procedure to get them (return list of IDs by CENTER, DISTANCE)

- need build SPATIAL INDEX - in separate tables (stored procedure is used to access the data)

- stored procedure input parameters: city coordinates + range

output: list of IDs of the hotels (POIs) within the range

C. - modify existing queries to use stored procedure instead of SQL sub-clauses

Yes, wee are stuck. My programmer report is:

I tried the logic given in PDF from Page 25, and I got an error "ERROR 1367 (22007): Illegal non geometric 'aswkb(a@0)' value found during parsing error." then I tried another solution with different distance function, it also didn't worked. then I tried the method mentioned here [url removed, login to view] but it also didn't worked for me. I don't know what can be the issue, it was returning no data for me. The only sql statement that returned some result was with out use of Spatial index, the sql statement that worked was this:

select (

3959 * acos (

cos ( radians(51.36364590032256) )

* cos( radians( latitude ) )

* cos( radians( longitude ) - radians(12.996535354492153) )

+ sin ( radians(51.36364590032256) )

* sin( radians( latitude ) )

)

) AS dist, title from `aj3_iproperty` WHERE `state` = 1 HAVING dist < 50 order by dist

where 51.36364590032256, 12.996535354492153 are latitude and longitude for Dahlen (Sachsen).

we are using:

Joomla 3.5.1 + about mysql: Server: Localhost via UNIX socket Server type: Percona Server Server version: 5.6.29-76.2-log - Percona Server (GPL), Release 76.2, Revision ddf26fe Protocol version: 10 User:

Skills: AJAX, HTML, Javascript, PHP, SQL

See more: what is the problem statement, what is problem statement, what is a problem statement, title search report, sql functions pdf, searching index of, parsing input, open table com, mysql city state database, logic challenge, loading function in php

About the Employer:
( 38 reviews ) Nitra, Slovakia

Project ID: #10635000

Awarded to:

joseluiselp

Hello I can help you with this, I'm very good with SQL and Databases. If you are interested please take a look at my feedbacks and let me know. Regards Jose Mendoza.

$17 USD / hour
(21 Reviews)
4.4

12 freelancers are bidding on average $19/hour for this job

drupaltonic

Thank you for the opportunity to let us submit our [login to view URL] have done many relevant projects in the past very similar to your requirements .So for sure you will get a perfect and skilled output from our [login to view URL] woul More

$20 USD / hour
(77 Reviews)
8.4
winmaclin

Hello, We are JOOMLA EXPERTS. And after reviewing your website at [login to view URL] and watching the video at [login to view URL] completely, and We consider ourselves apt fit t More

$15 USD / hour
(166 Reviews)
8.1
londonlance

We are a London based Fullstack dev studio, WE BUILT SILICON VALLEY LEAGUE PRODUCTS FOR A FRACTION OF THE COST. All our projects are version controlled with GIT (Github or Bitbucket). Following are some of our rece More

$23 USD / hour
(38 Reviews)
7.2
scriptphp87

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [login to view URL] More

$21 USD / hour
(241 Reviews)
7.9
sphinxsolution

Hi, This is Gaurav, Writing on behalf of Team Sphinx. We are one of the rapidly growing web and App Development Company based out of USA,Austrailia & Pune,India. We have developed more than 300+ solutions so More

$15 USD / hour
(12 Reviews)
7.2
mmadi

Dear Client, Greetings from Flowgica technologies, I have experience with these skills. We do have similar experience doing something similar to yours therefore I am looking forward to discuss and move ahead. please ch More

$20 USD / hour
(41 Reviews)
7.0
yasirk1979

Hello Dear Sir, I am Muhammad Abrar & have many years of experience in Web Development working on different technologies, my colleague is 6 years experienced designer, so I can work on your project. do you want to w More

$22 USD / hour
(8 Reviews)
5.7
starcoadmin

Hello, I have reviewed your project posting and would appreciate if we can discuss about it in more detail over private message to clear few doubts. We are a leading Information Management Company. We offer na More

$16 USD / hour
(8 Reviews)
5.7
khanmahmudcse

Hi, I’m dedicated professional Web and Desktop Programmer & Developer and also Team leader of my company. I have been working with challenge and hope to improve future plan with good network every client. If any clien More

$22 USD / hour
(1 Review)
2.4
aminabano16

Hi, My name is Amina Bano, i have 7 years+ experience in web design and development. For the past few years I have designed and developed many websites. I can strongly assure you that I will be able to provi More

$16 USD / hour
(2 Reviews)
2.5
LtSurge

I have checked your website and I understand that these delays need to be removed, it seems that you have a good idea of where these delays are, however a good idea before carrying on with modifications to the applicat More

$22 USD / hour
(2 Reviews)
0.4
richawork

We have gone through your requirements and well understood about the project. We have developed a wide range of websites. Our team is having tremendous experience working with different CMS and frameworks. In terms o More

$22 USD / hour
(0 Reviews)
0.0