Paradox?

I have work with a 500000 record, what do you recomend? ..paradox?
I programing with Delphi 5.0
chiroAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kretzschmarCommented:
hi chiro,

i will not give a recomendation, because that depends of context where and for what the data are needed.

Here are the Limits from borland:
part of http://www.borland.com/devsupport/bde/ti/TI159B.html :


      PARADOX LIMITS

      --------------

      127    Tables open per system (4.0 and earlier, 16 Bit, 32 Bit)

      254    Tables open per system (4.01, 32 Bit)

      64     Record locks on one table (16Bit) per session

      255    Record locks on one table (32Bit) per session

      255    Records in transactions on a table (32 Bit)

      512    Open physical files (4.0 and earlier, 16 Bit, 32 Bit)

                 (DB, PX, MB, X??, Y??, VAL, TV)

      1024   Open physical files (4.01, 32 Bit)

                 (DB, PX, MB, X??, Y??, VAL, TV)

      300    Users in one PDOXUSRS.NET file

      255    Number of fields per table

      255    Size of character fields

      2      Billion records in a table

      2      Billion bytes in .DB (Table) file

      10800  Bytes per record for indexed tables

      32750  Bytes per record for non-indexed tables

      127    Number of secondary indexes per table

      16     Number of fields in an index

      255    Concurrent users per table

      256    Megabytes of data per BLOb field

      100    Passwords per session

      15     Password length

      63     Passwords per table

      159    Fields with validity checks (32 Bit)

      63     Fields with validity checks (16 Bit)


meikl
0
MotazCommented:
That means Paradox is a very strong database format.

Motaz
0
rovermCommented:
I always use Paradox tables because
they are fast and very reliable (using them for about 4 years now...).
A very good alternative is building tables in sql-server 7 (I know, microsoft...) and letting Delphi talk to SQL via ODBC. The advantage is that SQL Server handles all locking, transactions and stuff. Very easy use of stored proc's, user priveleges and so on. Disavantange:
At 'first contact' slower than Paradox.

grtx, Mark
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

MotazCommented:
I read this page and I found:

>48     Clients in system
>300    Concurrent users

What did they mean by clients ?

and what is the difference between Clients and Concurrent users ?

Motaz
0
kretzschmarCommented:
hi motaz,

>48     Clients in system
comes from bde-limits part,
therefore i guess that are the max of installed databasedrivers

>300    Concurrent users
means 300 Concurrent users

meikl

0
rovermCommented:
Chiro,

I think (almost certian):
- One client is one instance of your Delphi app which connects to the database, so 48 instances of your application may be open, started from one position.
- 300 concurrent users in 1 net file means that the net file which controls the access to all tables in a database can handle up to 300 users at one time.
The 301st user will receive an error saying that the database is locked by another user!

grtx, Mark
0
rovermCommented:
Chiro,

I think (almost certian):
- One client is one instance of your Delphi app which connects to the database, so 48 instances of your application may be open, started from one position.
- 300 concurrent users in 1 net file means that the net file which controls the access to all tables in a database can handle up to 300 users at one time.
The 301st user will receive an error saying that the database is locked by another user!

grtx, Mark
0
MotazCommented:
Did you mean that when I use CGI-Stand alone executable only 48 instance -which use the same database table- can be loaded in the memory ?
0
rovermCommented:
Yes!
48 client can run at 1 BDE !!!!!
For example: if you would configure a netwerk: 1 server, 10 client workstations, each client has its own BDE, the server has its own BDE then each client (and the server) can connect to the LOCAL BDE 48 times (using threads).
In this example you can connect to your database 480 times from workstations and 48 times from the server.
If you connect from one PC for use with CGI script, you better use components (like a 3-tier environment) to connect to the database. This way you can control how many connections are made and destroy connections immediatly after use.

0
MotazCommented:
Which component I must use ? did you mean TDBSessoin ?
0
rovermCommented:
Nope ! Build your own component which connects to the database !!
If you don't know how to build one in Delphi you can try the Component creator version of Visual Basic 6.
Very easy to use: you can connect to your Paradox table via ADO and ODBC with full functionallity. You can return a complete recordset and so on!
This version is FREE ! See the microsoft website at http://msdn.microsoft.com/default.asp
look in Downloads, Tools and utils

grtx, Mark
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.