Open Development Platform

Eclipse Platform

Subscribe to Eclipse Platform: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get Eclipse Platform: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn

Eclipse Platform Authors: Janakiram MSV, Ken Fogel, Marcin Warpechowski, Michael Meiner, Liz McMillan

Cloud Development Tools : Blog Feed Post

Performance of Executing SQL with PostgreSQL on Alinous-Core

Everybody may guess if development is easier, then performence become worse.

Everybody may guess if development is easier, then performence become worse.

But by developing Alinous-Core, actually no problem about bad performance.

Alinous-Core is written in Java language, and using connection to PostgreSQL via JDBC. And Alinous-Core use precompiled statement as possible as it can.

Almost all SQL are executed as precompiled statement.

If you are going to use precompile statement in Java or other language, you have to write program to use it.

But in the case of Alinous-Core, just write SQL.

Alinous-Core has internal SQL compiler and check if executing as precompiled statement for the SQL  is available or not automatically.

When SQL executed, the console of eclipse IDE shows you. Then "[CP]" or "[P]" is in front of the executed SQL, Alinous-Core use precompiled statement automatically.

like bellow

[P] means precompiled statement, [CP] means cached precompiled statement.

Alinous-Core has own thread pool and managing precompiled statements,  and cache them.

Read the original blog entry...

More Stories By Tomohiro Iizuka

Tomohiro Iizuka is CEO of company which is publisher of third-party logistics and e-commerce software in Japan. And my speciality is making programming language and development environment. Actually developed Alinous-Core programming language and development tool working on eclipse plugin. By making computer language, I succeeded in providing enterprise application rapidly to Japanese customers.