The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
We utilise an ASP.Net web services wrapping and SQL Server Database to store objects and hierarchical label structures for use in a collaborative modelling system.
The handling of labels on check-in and check-out is becoming a performance barrier, and we wish to both exercise a step-change in the performance of these queries and to ensure the scalability of the database with regard to label handling.
The current system utilises stored procedures and temporary tables to perform the check-in and check-out queries for labels on the database, and C# code to parse and generate XML files used to transport data over the web service. We require the consultant to:
1. Review the existing table structure (as it relates to labels, n tables) and design and implement changes to the table structure if the consultant can show this will result in significantly enhanced performance. In reviewing the table structure the consultant should also review the scalability of the system and the client wi...
Sign in or Register to see more