Pesquisar

Anúncio
· Set. 25

InterSystems Ideas News #25

Hi Community!

Welcome to Issue #25 of the InterSystems Ideas newsletter! Let's look at the latest news from the Ideas Portal, such as:

✓ General Statistics
✓ Recently added Community Opportunity ideas

   Here are some August numbers for you. During last month, we had:

  • 4 new ideas
  • 13 implemented ideas
  • 27 comments
  • 49 votes

👏 Thanks to everyone who contributed in any way to the Ideas Portal last month!

  Just in time for the new InterSystems External Languages Contest, here's a list of new Community Opportunity ideas:


✨ Share your ideas, support your favorites with comments and votes, and bring the most interesting ones to life!

Discussão (0)1
Entre ou crie uma conta para continuar
Artigo
· Set. 25 1min de leitura

Ganhe certificados sobre tecnologia InterSystems

certification badge

Com os exames de cerficação padrão de indústria da InterSystems, você e seu time podem ganhar certificados qeu validam suas habilidades e demonstram sua expertise em tecnologia InterSystems. Encontre o teste correto para sua posição!

Discussão (0)1
Entre ou crie uma conta para continuar
Artigo
· Set. 25 2min de leitura

About parallel queries (%PARALLEL)

InterSystems FAQ rubric

One way to optimize query performance is to use query parallelism on a per-query or system-wide basis (a standard feature).

This is a technique for dividing the execution of a particular query among processors on a multi-processor system. The query optimizer will execute parallel processing only if there is a possibility of benefiting from parallel processing. Parallel processing is only applicable to SELECT statements.

Note that the number of parallel processes cannot be specified, as it is automatically adjusted according to the number of CPUs. You can check the current number of processors in your system with the following command.

USER>write $SYSTEM.Util.NumberOfCPUs()
8

Previously, parallel processing was enabled by adding the %PARALLEL keyword to a query, but from IRIS2019.1 onwards, the default is "always enabled".

Management Portal:
  System Administration > Configuration > SQL and Object Settings > SQL
    Execute queries in a single process
    *Check this box to disable parallel processing (default is unchecked)

To disable parallelism on a per-query basis, specify the %NOPARALLEL keyword.

SELECT * FROM %NOPARALLEL Sample.Person WHERE ...

Note:
Specifying %PARALLEL may degrade performance for some queries. For example, specifying %PARALLEL when executing a query on a system with multiple concurrent users may result in overall performance degradation. In this case, use %NOPARALLEL to disable parallel processing for each query, or set the system-wide setting to "Execute queries in a single process."

For more information, see the following document: Query Parallelism
 

Discussão (0)0
Entre ou crie uma conta para continuar
Artigo
· Set. 25 2min de leitura

Create a JDBC connection with Mysql Cache

When we need to integrate Caché/IRIS with other relational databases, one common question arises: “How do I set up the JDBC connection?”.
The official documentation doesn’t always provide a straightforward step-by-step guide, which can be frustrating, especially for beginners.

In this article, I’ll walk you through the entire process of configuring a JDBC connection with MySQL, from downloading the connector to linking tables in Caché/IRIS.

Note: JDBC connections in Caché/IRIS have some limitations, especially regarding caching and the use of ResultSet. In many cases, you may need to adapt queries manually and use the Gateway object to handle advanced scenarios.

1. Download the MySQL JDBC Connector

The first step is to download the official MySQL JDBC driver.
Go to: https://dev.mysql.com/downloads/connector/j/

2. Make the Connector Accessible

After downloading:

  1. Extract the package.
  2. Locate the .jar file (e.g., mysql-connector-j-9.4.xx.jar).
  3. Copy the file to a folder accessible to Caché/IRIS, for example:


3. Configure the Connection in the Management Portal

Now, let’s set up the connection inside the Management Portal:

  1. Open the Caché/IRIS Management Portal in your browser.
  2. Navigate to Gateway Sql Connections
  3. Click “Create New Connection”.




Create a new connection and configure it using the example provided.

,

4. Link External Tables

  • Go to a SQL in Menu, assistant > link table
  • Click Assistant > Link Table.
  • Select your connection (MySQL_Conn).
  • Choose the tables you want to link.
  • Confirm.

And put the necessary settings, this part is easy and very suggestive, once this is done your jdbc connection is ready, you can see on the sql screen itself the bank, the table and can bring the data, remember that mysql uses backquotes to form select and the cache uses double quotes which can be a problem when doing some select

After mapping the tables, you will be able to view them under the Tables tab in the SQL screen.

5. SQL Syntax Consderations

One common issue:

  • MySQL uses backticks (`) for table and column names.
  • Caché/IRIS uses double quotes (") for identifiers.
  • By selecting the appropriate options in the Gateway configuration screen (as shown in the screenshot), you can resolve this issue. However, you may also choose to leave it unchanged for any reason.

This can cause problems in queries. If needed, manually adjust the syntax when writing SQL statements.

Conclusion

And that’s it! You now have a working JDBC connection between Caché/IRIS and MySQL.

With this setup, you can:

  • Query MySQL data directly from Caché/IRIS.
  • Link tables to your namespace for easy integration.
  • Automate data exchange between systems.

Even though JDBC in Caché/IRIS has some limitations, this configuration covers most integration needs in a practical way.

1 Comment
Discussão (1)2
Entre ou crie uma conta para continuar
Pergunta
· Set. 25

Car Engine Service in Dubai – Quick Fit Auto Center

When it comes to keeping your car running smoothly, your engine is the heart of the vehicle. Just like the human body needs regular checkups to stay healthy, your car’s engine requires timely inspections, servicing, and repairs to deliver peak performance. For drivers in Dubai, where high temperatures, busy roads, and long drives are a part of daily life, professional car engine service in Dubai becomes essential. At Quick Fit Auto Center, we specialize in providing comprehensive engine diagnostics, repair, and maintenance services that ensure your car stays reliable and powerful on the road.


Why Car Engine Service is Important in Dubai

The engine is the most complex and critical part of your car. A well-maintained engine improves fuel efficiency, enhances performance, and prevents unexpected breakdowns. In Dubai’s unique driving conditions, where cars are often exposed to extreme heat and long commutes, engines are put under significant stress. Ignoring engine maintenance can lead to overheating, reduced performance, and costly repairs.

By investing in regular car engine service in Dubai, you not only extend the lifespan of your car but also ensure safety, reliability, and long-term cost savings. At Quick Fit Auto Center, we provide specialized care that addresses both preventive maintenance and complex repairs.


Common Signs Your Car Needs Engine Service

Many car owners overlook early signs of engine trouble. However, catching these symptoms early can prevent major damage:

  • Check Engine Light – If the light on your dashboard is on, it’s time for a diagnostic check.
  • Unusual Noises – Knocking, ticking, or grinding sounds indicate internal issues.
  • Excessive Smoke – Blue, black, or white smoke from the exhaust signals serious engine problems.
  • Overheating – In Dubai’s climate, overheating is common if engines aren’t maintained.
  • Loss of Power – A sluggish response or reduced acceleration means your engine needs servicing.
  • Poor Fuel Efficiency – If you’re visiting the fuel station more often, your engine may need tuning.

If you notice any of these signs, bringing your car to Quick Fit Auto Center for a professional engine service in Dubai can save you from expensive repairs later.


Comprehensive Car Engine Services at Quick Fit Auto Center

At Quick Fit Auto Center, we offer a wide range of car engine services in Dubai tailored to meet the needs of every make and model. Our highly trained technicians use advanced diagnostic tools and genuine parts to ensure precision and quality.

1. Engine Diagnostics

We use cutting-edge computer diagnostics to identify issues accurately. Whether it’s a faulty sensor, wiring issue, or internal problem, we detect it quickly and recommend the right solution.

2. Engine Repair

From minor fixes to major overhauls, our experts handle all kinds of engine repairs. This includes gasket replacement, timing belt replacement, fuel injection system repair, and more.

3. Engine Overhaul & Rebuild

When the engine suffers extensive wear, we provide complete overhauls and rebuilds to restore it to factory performance.

4. Oil Change & Filter Replacement

Regular oil changes are essential in Dubai’s hot climate. We ensure your engine runs smoothly with high-quality oils and filters.

5. Cooling System Service

We inspect and repair radiators, water pumps, and thermostats to prevent overheating – a common issue in Dubai.

6. Preventive Maintenance

Our preventive maintenance plans include regular inspections, fluid checks, and servicing to catch problems before they escalate.


Why Choose Quick Fit Auto Center for Car Engine Service in Dubai?

There are many service centers across Dubai, but Quick Fit Auto Center stands out because of our commitment to quality, transparency, and customer satisfaction. Here’s why drivers trust us:

  • Expert Technicians – Our team is trained to handle all types of engines, including luxury, exotic, and high-performance cars.
  • Advanced Equipment – We use the latest technology for diagnostics and repairs.
  • Genuine Parts – Only authentic and high-quality parts are used to ensure durability.
  • Affordable Pricing – We provide premium services at competitive rates.
  • Customer-Centric Approach – Our priority is your satisfaction and your car’s reliability.
  • Wide Range of Services – Beyond engines, we provide full car care including transmission repair, AC service, suspension work, and more.

When it comes to car engine service in Dubai, Quick Fit Auto Center is a trusted name that car owners rely on.


Engine Service for All Car Makes and Models

One of the key strengths of Quick Fit Auto Center is our ability to service engines from all car brands. Whether you drive a European luxury car, an American SUV, or an Asian sedan, our technicians are equipped to handle it. We provide specialized engine services for:

  • German cars such as BMW, Mercedes-Benz, and Audi.
  • British brands like Land Rover, Jaguar, and Bentley.
  • American vehicles including Ford, Chevrolet, and Dodge.
  • Japanese cars such as Toyota, Nissan, and Honda.
  • Exotic cars like Ferrari, Maserati, and Lamborghini.

No matter the make or model, our engine service in Dubai ensures your car runs at peak performance.


Benefits of Regular Car Engine Service

Investing in professional engine service in Dubai at Quick Fit Auto Center offers multiple advantages:

  • Increases the lifespan of your vehicle
  • Boosts fuel efficiency and saves money on fuel
  • Prevents costly breakdowns and major repairs
  • Enhances performance and driving comfort
  • Improves safety for you and your passengers
  • Maintains the resale value of your car

Convenient Location and Easy Booking

Located in Dubai, Quick Fit Auto Center makes it easy for car owners to access expert services. You can book an appointment online or visit our workshop directly. Our team ensures fast turnaround times without compromising on quality.


Final Thoughts

Your car’s engine is its most vital component, and keeping it in top shape should never be ignored. Whether you need diagnostics, repairs, or preventive maintenance, choosing the right service center is key. At Quick Fit Auto Center, we provide professional car engine service in Dubai that guarantees performance, reliability, and peace of mind. With a team of skilled experts, advanced tools, and a customer-first approach, we make sure your car is always road-ready.

For trusted car engine service in Dubai, look no further than Quick Fit Auto Center – where quality meets excellence.

Discussão (0)1
Entre ou crie uma conta para continuar