Optimize a store proc - Find point sort by distance

$10-300 CAD

Terminado

Publicado

hace más de 9 años

$10-300 CAD

Pagado a la entrega

I have a database i need to get real good performance. I'm on MS SQL 2012 and 2014. I use a field spatial and i need to show to the user the point nearest. i use for the a order by with the SPDistance. But, it's take arround 8 sec only for that, then when i add some join on other table. The performance drop. I'm looking for real performance. The stored proc need to show data on maximun 1 sec. My problem are not realy complex. All the website or mobile app who have a feature to find stuff near then already made that. Thank you!

.NET

Geolocation

Microsoft SQL Server

ID del proyecto: 6858521

Información sobre el proyecto

6 propuestas

Proyecto remoto

Activo hace 9 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

Adjudicado a:

@mpalgeo

Hi I have been working with MSSQL for over 14 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

$100 CAD en 2 días

5,0

(10 comentarios)

3,4

6 freelancers están ofertando un promedio de $147 CAD por este trabajo

@customizedata

I have GIS degree holder. I can optimize the stored procedure. Did you use the spatial index on the geometry datatype ?

$190 CAD en 2 días

4,9

(70 comentarios)

6,1

@nviqar

I have been developing database driven web mapping applications for over 7 years now. And have used SQL Server 2008 - 2014 for storing and querying spatial data. I understand why you might be having the performance issue and I can should be able to resolve it quickly. Thanks for the invite. Nadir Viqar

$111 CAD en 1 día

4,8

(1 comentario)

3,0

@kmpal

Hi, I am an experienced developer with vast experience in .NET, MVC and SQL available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid Skype - khalidpal 00 92 333 421 72 89 - WhatsApp / Viber

$172 CAD en 2 días

4,8

(1 comentario)

2,4

@akaloshych

Предложение еще не подано

$166 CAD en 2 días

0,0

(0 comentarios)

0,0

@DSMauricio

Hello, i have a lot of experience in sql server since version 6.5, i can help you with the optimization, just write to me, and lets get started right away.

$144 CAD en 3 días