Since Weknow Healthtech creates analytics software, naturally, the queries to obtain certain data are frequently used. However, the software architecture and the solutions the company has implemented to retrieve data were slowing down overall performance, negatively affecting user experience.
Alexandre da Silva, being deeply involved into software development processes, looked for an option to boost the solution’s performance and searched for a way to let the system handle larger amounts of data without it going through bottlenecks. That’s when he decided to try Oracle Data Access Components (ODAC) to check if this solution would do better at data connectivity tasks. As a result, it became possible to scale the system Alexandre was working on, and the performance of the custom solution significantly improved.
Weknow Healthtech team works on complex data-driven analytics projects aimed at fulfilling clients’ business needs, which makes them look for the best ways to improve data handling. ODAC from Devart made it possible for the company to achieve the much-needed performance boost whenever the queries involved obtaining extensive data volumes.
When it comes to exporting data to files, the more extensive data volumes there are, the more time it takes to complete. However, with ODAC from Devart, it data export queries work faster, helping significantly improve data export.
ODAC-based database applications are simple to deploy and don’t rely on additional data provider layers like BDE or ODBC. This streamlined setup allows them to perform faster compared to applications built using standard Delphi data connectivity solutions. Furthermore, ODAC offers the added benefit of connecting to Oracle directly over TCP/IP, eliminating the need for an Oracle Client.