Very slow queries

MartinGunnarsso

New Member
Hi everybody

I'm developing a program in Java, that talks to a Progress 9.1C database. Now, it seems like all my database queries take very long time, like 300-600 milliseconds. The progress people told us the SQL interface was slower than the 4GL interface, but it shouldn't be THIS slow, right? In that case the database is completely unusable.
What are your experiences?

Thanks!

--
Martin Gunnarsson
 
Martin,

Could you please tell me how are you connecting Progress 9.1C from Java. As we are all aware that Java has different types of JDBC drivers. Please check the drivers provided by Progress for java. I think a thin-client driver is faster and more reliable than ODBC.

Thanks,
Ajay.
 
I'm connecting using the Progress JDBC drivers that came with the installation. I think the major files are called progressjdbc.dll and progress.zip.
 
We only used Progress because we had licences from an earlier project, instead of wasting time on a product we didn't really like we switched to MySQL. The few changes necessary took about half a day to make, and we certainly never looked back. As an SQL database MySQL is superior in every way, plus it's extremely easy to get your questions answered from the very large and active user base.
 
We only used Progress because we had licences from an earlier project

That sounds like a strange basis on which to decide how to develop an application, particularly as you imply you weren't using 4GL (the reason for using Progress for development).

As an SQL database MySQL is superior in every way,

Probably so, but 'SQL' is an important qualifier. The whole point of using Progress is access to the 4GL, which is superior to SQL for creating business logic. I wouldn't personally use Progress except for the 4GL.

plus it's extremely easy to get your questions answered from the very large and active user base.

You are right that Progress as a niche (and expensive) product will always struggle against the main and free players for user activity though.
Bear in mind that this particular forum is relatively inactive compared to the main Progress forum at www.peg.com.

I'll grant you that connectivity problems are not always adequately answered (even on the Peg), but you are asking questions about communicating via a 3rd party product - always best to go through the appropriate tech support channels in those cases, as well as trying the forums.

Good luck with MySQL.
 
Well, whatever, man. I've seen applications developed in 4GL, not a pretty sight. We needed an SQL database and had Progress installed on the development machines, beginning the development using it seemed like a pretty straight-forward thing to do. Since most modern applications are build in tiers there's usually no problem to replace the database stuff.

By not building your application in a database you'll still have the option to change databases in the future. You're not tied to a proprietary system with a proprietary language. The minor differences in SQL between different databases are easily isolated to a single file.

Besides, during the development of our system we didn't have to pay a penny for MySQL, now that we're using it we obviously pay for the two server licences we need, but they are an awful lot cheaper than the ones for Progress.
 
Well, whatever, man. I've seen applications developed in 4GL, not a pretty sight.

I've seen ugly applications in every language I've ever worked with. That's normally down to unrealistic schedules, 'fast' programmers and the resulting Big Ball of Mud. The language isn't often to blame.

Since most modern applications are build in tiers .

Like modern Progress applications.

there's usually no problem to replace the database stuff. By not building your application in a database you'll still have the option to change databases in the future.

That's true, but there is the tradeoff in using Progress: lack of portability of 4GL code (although there's always DataServers), because of the inferior SQL industry standard, against great business side development productivity. You pays your money...

You're not tied to a proprietary system with a proprietary language.

You're always tied to an extent, particularly with your GUI choices, as they will always change the most against a well designed business and database side.

You program in VB5, then along comes Visual Fred. You develop in Delphi and Borland goes under. There are no guarantees in this business.

One of the most exasperating things for me about Progress is it's determination to remain backwards compatible to the most primitive front end versions.

Many people however, see this as a good thing, one of the strongest arguments in favour of Progress. Presumably you must too.

The minor differences in SQL between different databases are easily isolated to a single file.

Not if you use any SQL 'enhancement', T-SQL, PL-SQL, etc.

Besides, during the development of our system we didn't have to pay a penny for MySQL, now that we're using it we obviously pay for the two server licences we need, but they are an awful lot cheaper than the ones for Progress.

Now that's something we can agree on.
 
OK... I've read very fast... Only I have a simple question...

Are you going to connect Progress with MySQL? How are you going to do this.... Are you going to use the ODBC Dataserver or which product?

Thanks... I want to connect MySql with Progress in order to transfer information directly using 4GL.
 
Back
Top