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

Dokončeno Zveřejněno před 7 lety K zaplacení v momentě doručení
Dokončeno

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:

AJAX HTML JavaScript PHP SQL

Identifikační číslo projektu: #10635000

O projektu

12 nabídek Projekt na dálku Aktivní před 7 lety

Uděleno uživateli:

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 / hodina
(21 recenzí)
4.4

12 Freelnceři na váš projekt zveřejňují nabídky v průměru $19/hod.

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] Další

$21 USD / hodina
(241 Recenzí)
7.9
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 Další

$20 USD / hodina
(41 Recenzí)
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 Další

$22 USD / hodina
(8 Recenzí)
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 Další

$16 USD / hodina
(8 Recenzí)
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 Další

$22 USD / hodina
(1 recenze)
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 Další

$16 USD / hodina
(2 Recenzí)
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 Další

$22 USD / hodina
(2 Recenzí)
0.4