Open
Expired

Database script optimisation (reporting)

Posted by Keiron C.

Location

Remote

Due date
Saturday, 16th Sep 2017
Details
We have a custom built relational database using FileMaker for stock management purposes.
Calculation and summary fields are slowing down the reporting to a snails pace.
5-10 minutes through about 100,000 records.
It's becoming unusable.

Can provide access to dev database or send the files.
We can work together to make it happen.
No strict deadline or budget.

Hosted on windows server 2016
Local and Remote eClients using Mac and Windows
Filemaker server 2016 - Must have filmmaker 2016 to develop.
Offers
Goran B.
(7)
100%Completion rate

The percentage of accepted tasks this Tasker has completed.

Hi Keiron, I am a full stack dev with over 8 years experience working with relational and nosql databases; to be honest 100k records is not many records to be taxing the system unless the database is running on a potato of a machine.

I am happy to spend some time on your development database and see if we can increase the performance. I am assuming you have some scripts to run for benchmarking purposes. My quote is accurate and I will have you up and running very quickly. Please see my reviews.
1 year ago
Ella A.
New!
No Completion rate

The percentage of accepted tasks this Tasker has completed.

I believe I am the ideal candidate for this task. I have experience in data entry that i have from my internships that I have done for uni. I am highly capable of performing this task.
1 year ago
Sara R.
(26)
71%Completion rate

The percentage of accepted tasks this Tasker has completed.

I run a Web designing web agency in South Wharf Victoria. With 10+ years of experience. I have the perfect skill set to help you with this task.

You’re looking for a SQL Expert for your work and this is exactly what I specialize in. Talk about a perfect match!

I’ll keep this short and we can go into more details when we chat.
1 year ago
Peter H.
(1)
No Completion rate

The percentage of accepted tasks this Tasker has completed.

I am a FileMaker developer with over 20 years experience. I look forward to assisting you with the database.
1 year ago
Varun B.
(73)
83%Completion rate

The percentage of accepted tasks this Tasker has completed.

Would be happy to help. Ive worked with Filemaker a while ago but have overall 15 years managing and optimising relational and more recently NoSQL databases

Thanks
Varun
1 year ago
Christopher M.
(27)
96%Completion rate

The percentage of accepted tasks this Tasker has completed.

It has been many years since I used and taught FileMaker Pro. But likewise, I have decades of experience developing software and databases, and I specialise in analysing and improving problematic software. Please check the reviews on my profile.
1 year ago
Deleted account D.
(9)
93%Completion rate

The percentage of accepted tasks this Tasker has completed.

FileMaker Expert, can start now
1 year ago
Task Activity
26 comments about this Task
Comments are now closed
Keiron your task will expire today but you can extend it (before it expires) or re post it any time, have a great day!
Hi Keiron, Just like to mention that based on some communication with FileMaker Pro reps from the USA, I have the most up to date information about all issues of FileMaker Pro 16 scripts and I also know how to solve those issues. Based on this information and to solve your scripting problems, it may take longer then the deadline of this task. You may need to extend the task and or open a new task.
Hi Keiron, I am still available to do the task if required. You could post me the database on a memory stick will give you my Post Office Box. All your data and database will remain confidential
Have a strong DB experience. If you share more details on the prob pretty sure I can tell you what it takes to fix it. 100k records is nothing for db there is something fundamentally wrong with SB schema or server.
Thank you for keeping us appraised, Keiron.
0 new tasks