Devam Ediyor

Oracle SQL Speedup

Here is the problem:

We represent a hierarchy of related record with a two column DB table called dataRecordRef. The columns are recordId and parentRecordId. A child record can have more than one parent record, so in this hierarchical representation there can be more than one path to the root for any given record.

We need a fast way given a set of record id's, what all it's descendant records are...namely a list of all the given records paths to the bottom of the tree. We have coded a solution as a single query that works, but we are unsatisfied with its performance.

We are fine if the solution is a single query like we coded, or if its a stored procedure.

We will pay more for more speedup over our current solution. In other words if you are 2x faster you can get more than if you are [url removed, login to view] faster. We would really like to see 10x performance as that is the performance we get with a MySQL stored procedure and we feel like we should be able to at least equal that on Oracle.

We include the following files:

* the dataRecordRef table as a CSV file you can import for testing

* the example query that we created that works but is too slow

* the input record ids as a csv that you will take as inputs to compute their ancestors against the provided dataRecordRef table

We will pay $100 for each doubling of performance up to 10x, which would be $1,000 award.

Beceriler: Veritabanı Geliştirme, Veritabanı Programlama, Oracle

Daha fazlasını görün: tree query, sql query to get list of database, root words tree, procedure sql oracle, bottom up programming, what is performance testing, oracle sql with, oracle performance, sql created, development oracle, import sql database mysql, query performance, stored procedure list, sql oracle development, query sql tree, oracle sql development, import database oracle, sql file csv, 100 words tree, mysql query slow, testing oracle, csv import sql database, database procedure, mysql table import file example, sql tree parent child query

İşveren Hakkında:
( 0 değerlendirme ) Chennai, India

Proje NO: #6506813

0 freelancer bu iş için ortalamada $ teklif veriyor

smbdintelligent

Dear I'm Oracle Certified Professional, & very interested to do this task with 100% accuracy of your demand, and will be finish within very short time, because this task is very easy for me. Thanks and best regar Daha fazlası

in 10 gün içinde750$ USD
(0 Değerlendirme)
0.0
Sshram

A proposal has not yet been provided

in 20 gün içinde1250$ USD
(0 Değerlendirme)
0.0