Solved

Delphi + Databases

Posted on 2002-03-04
12
179 Views
Last Modified: 2013-11-23
Hey everyone, i need to know some powerful database enginers to use with delphi 5 and windows NT, the tables that i will use have about 800,000 rows.... i tried Mysql but is a little slow.
With your experience, could you recommend me some database enginers, and i need that the databases are GPL.

Thanks.
0
Comment
Question by:amphill
  • 4
  • 3
  • 2
  • +3
12 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6839509
what is GPL?
German Parcel Logistics?

nevertheless 800000 rows are not much
and mySQL should be fast enough,
well not as fast as oracle

if you want performance, then
- your database design must be good,
- the hardware must be good
- your connectivity must be fast
- your access-statements must be very well designed

performance is not a question of delphi

meikl ;-)



0
 
LVL 17

Expert Comment

by:inthe
ID: 6839602
meikl,
agree with your comments but

haha "German Parcel Logistics" ,i think he means
General Public License
http://www.gnu.org/copyleft/gpl.html :-)
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6839712
thanks for clarify, barry,
but i heard so often gpl in another context like
Gesellschaft für Privaten Logistikservice
German Parcel Logistics
God Peace Love
etc.

:-))
0
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 
LVL 1

Expert Comment

by:edsteele
ID: 6839905
I would use the free version of InterBase.

http://www.ibphoenix.com/

It doesn't use the GPL.  It uses another version called IPL which is geared specifically toward InterBase.

Eric
0
 

Expert Comment

by:MLri
ID: 6840357
Hi Amphill,
Please try Interbase ( commercial ,open source or  Free).
i think , use Store Procedure can reduce alot of network overhead(traffic) from your network.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6840935
hu,
IPL
Internet Packet Layer?
0
 
LVL 1

Expert Comment

by:edsteele
ID: 6841310
InterBase Public License

These TLAs are getting out of hand!  (Three-Letter Acronyms)  :)
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6841360
well, was just kidding :-))
0
 
LVL 17

Expert Comment

by:Wim ten Brink
ID: 6846861
I guess an Oracle Personal edition database is out of the question here? This would give you a free, powerful database but unfortunately you cannot use this version for commercial or productional purposes. You can only use it to create applications that support Oracle databases.
0
 

Author Comment

by:amphill
ID: 6847554
Thanks everyone for you comments!!,  i think i'll try Interbase and oracle too.
Just a question (For interbase and oracle); can i use this databases for free, i mean they would be free, if all my machines were accessing to anyone of these database (only in my organization, the system would not go out of here); i have a few machines, like 15.
0
 
LVL 1

Accepted Solution

by:
edsteele earned 70 total points
ID: 6847695
InterBase (Phoenix), absolutely, use it anywhere you like with NO fees.

Oracle (Personal Edition), maybe, but I doubt it.  I believe you are only supposed to use the Personal Edition for development.  I'm shooting from the hip here, I havn't read the Oracle Personal Edition license.  Once you start using it as a "production" database, you are supposed to buy a "real" copy.
0
 
LVL 17

Expert Comment

by:Wim ten Brink
ID: 6850518
Yep. Oracle Personal Edition is for development only. But it's a good database to use while developing your software. Once the project is finished you might consider using a different database, if you've created the application in a way that you can easily switch databases. (Either by using the BDE with an alias or by using e.g. ADO/OLE DB.)
There is a free version of Interbase called IBPhoenix or Firebird but unfortunately Interbase doesn't perform that well. Like MySQL it is a bit slow.
Then again, Oracle is not a GPL product and it's even quite expensive and not easy to get. Once you're done with developing and want to start using it professionally you have no other option than to buy Oracle.

If you want it for free, use Interbase. If you can afford to pay for it, use Oracle.
0

Featured Post

Are your AD admin tools letting you down?

Managing Active Directory can get complicated.  Often, the native tools for managing AD are just not up to the task.  The largest Active Directory installations in the world have relied on one tool to manage their day-to-day administration tasks: Hyena. Start your trial today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
TVirtualStringTree  search using TEdit 7 121
How to call a form that is in a DLL  from an application? 13 71
RESTRequest Parameter 4 30
Delphi problems to abort a printjob 9 19
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question