Parallel = the holy grail of speed! Sometimes, but in this case it does. Why on Earth does IQ only allow you to create indexes with parallel option? Ask Sybase! BEGIN PARALLEL CREATE HG index idx_1_HG ON <table> (column_1); CREATE LF index idx_2_LF ON <table> (column_2); CREATE HG index idx_3_HG ON <table> (column_3); …… on …
IQ_SYSTEM_MAIN, IQ_SHARED_TEMP, and IQ user main dbspaces are shared by all multiplex servers, and all servers need access to the same physical file. Data managed by SQL Anywhere is not shared. Each node requires a separate copy of such data. Each server has its own set of files in IQ_SYSTEM_TEMP and IQ_SYSTEM_MSG. Note: It is always recommended to create …
In Sybase IQ no two users can modify data in the same table at the same time. When you try to do this you will get an error in your application, as well as in the IQ message file. In IQ you can also run into problems when your transaction tries to modify something but …
Configuring your database systems for security is also known as database hardening. Doing this can significantly limit the vulnerability of your sensitive data. Designing for security means understanding the best practices for database configuration and applying them to your database environments efficiently. Specific database configuration settings are unique to each database system based on the …
The healthcare industry has been facing significant disruption in recent years, due largely to the Affordable Care Act (ACA). ACA has changed the landscape in how medical records are maintained. Many healthcare providers, especially smaller ones, had not previously implemented an electronic medical records system when ACA was first enacted. With the implementation of the …
A Data Warehouse Solution Should Provide Easy Access to Healthcare Data Read More »
Elevate Your Business With The Right Database Strategy An Effective Database Strategy for Your Business Your business’s database strategy must be developed with consideration for the varying database technologies that are available on the market and how they can be used to support the data used by your business. We start with a full evaluation of the data needs of …
As Sybase continues to get more difficult to justify, many organizations are feeling the pressure to upgrade to SAP HANA, rewrite their applications and/or migrate to a different database platform like SQL Server or Oracle. What if you could get a few extra years out of your current Sybase installation? What if you could have …
Get SAP HANA Performance Out of Your SYBASE Database for 1/10th the Cost Read More »
Welcome to WordPress. This is your first post. Edit or delete it, then start writing!
Ready to elevate your skills? Reach out to Dobler Consulting. Discuss your tech goals, and let us guide you on how to achieve them. Leveraging our wealth of knowledge and experience, we provide insights tailored to your needs, setting you on the path to industry excellence.
info@doblerconsulting.com