I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

August Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Setup, Vista, etc. Topic   Print This     

comparison between Pardox and Access

comparison between Pardox and Access in Paradox Setup, Vista, etc. topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: comparison   between   comparison between   comparison between Pardox  
Ted Pastuszak
Woodbridge, NJ, USA

I've been using Paradox from V4.0 through V9, relying on Mike Prestwood's books to get excellent results.
The pressure is on to convert or adopt to Access for future database/progamming, but I was always under the impression that Paradox was more stable, and overall a better product. If this is true, is there any chart or table available that compares the two, or at least some indication as to Paradox's strong points in relation to Access? This is a bit urgent, Thank you!

 Posted 18 years ago (Thread Starter)
Comment Quote
About Ted Pastuszak -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #922, 4 replies
Thread Started 2/7/2001 9:54:00 AM
View Counter=2974
Last Reply Posted 1/16/2018 10:41:42 PM)
Location=Woodbridge, NJ, USA  
Joined=18 years ago   MB Posts=5  
Most Recent Post
Moderator
Mike Prestwood
Prestwood IT
Prestwood IT office in Citrus Heights, CA
Fred:

Here's my two cents.

Conceptually, I like to separate the front-end (Paradox, Access, Delphi, Visual Basic, etc.) from the data storage (Access, Paradox, MS-SQL, Oracle). A well written application to either a local file based database or to an SQL server will perform very well. I personally prefer Paradox .db tables for local file based storage, but keep in mind that local file based databases like Paradox .db, Access .MDB, dBASE .dbf, etc. all are limited with respect to how much data AND how many users AND how many transactions they can handle. In addition to learning and using a really good local database like Access .MDB and Paradox .DB, I'd recommend learning and using one SQL server. As far as SQL servers go, I like to work with Oracle, MS-SQL, and Interbase myself.

Here are some general rules of thumb I use to guage when to move to an SQL server.

I start thinking about migrating when I get to the following limits. I don't necessarily migrate at this time, but I do start planning.



  • Size - When my database gets to over 100 MB of data or 500,000 rows of data.
  • Users - When the number of users gets above 15 to 20 "simultaneous" users.

  • Transactions - When the number of writes (not reads) exceeds 50 per minute.




These are just guidelines not absolutes. Obviously a well written application that uses a Paradox or Access database will perform well beyond the limitations listed here. However, both the amount of work a programmer must do and that programmer's amount of talent (experience) rises with these limits.


------------------
Michael A. Prestwood
Author, Corel Paradox 9 Power Programming: The Official Guide


President & CEO
Prestwood Software & Consulting
7525 Auburn Blvd., #8
Citrus Heights, CA 95610



Old UBB Archived Link: [URL=http://www.prestwood.com]www.prestwood.com[/URL]



Serving your IT needs since 1984!

--
Mike Prestwood
Prestwood IT Solutions

 Posted 18 years ago
Comment Quote
About Mike Prestwood -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Mike Prestwood

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Web Presence
Facebook, Prestwood IT Facebook page -- fan page. (Visit Me)
Twitter, Follow Prestwood IT on Twitter. (Visit Me)
LinkedIn, Prestwood IT company page on LinkedIn. (Visit Me)
YouTube, Prestwood IT YouTube Channel (Visit My Channel)
Website, My drum website where I sell my drum books. (http://www.play-drums.com)

Post ID #1042 (Level 1.1)  Reply to 922
Thread Started 2/20/2001 7:14:00 AM
View Counter=2
Location=Prestwood IT office in Citrus Heights, CA 
Joined=19 years ago   MB Posts=1410   KB Posts=1805   KB Comments=73   BLOG, Topics=4  
Rick Carter
Cincinnati OH USA
Yep, same old story. If it's not that, it's trying to convince people that Delphi is the premier Windows programming language, with all the ease of programming of VB, but all the power and flexibility of C++. But I digress.

If you need as much "ammunition" as possible as soon as possible, I would say go to
Old UBB Archived Link: [URL=http://www.deja.com/usenet/]http://www.deja.com/usenet/[/URL]
and do a search for all archived articles on the topic from comp.databases.paradox

------------------
Rick Carter
Rick Carter
Chair, Delphi/Paradox SIG
Cincinnati PC Users Group
 Posted 18 years ago
Comment Quote
About Rick Carter -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #935 (Level 1.2)  Reply to 922
Reply Posted 2/8/2001 9:17:00 AM
Location=Cincinnati OH USA  
Joined=18 years ago   MB Posts=518  
AIBreveleri
Don't neglect to require those applying the 'pressure' to provide their own chart showing, point by point, why Access is better than Paradox.

A point just occurred to me: Can Access be scaled up to two-tier (aka client/server)? That is, can Access forms and reports be re-attached to a standard SQL data server? Paradox does this nicely.

-Al.


[This message has been edited by A. I. Breveleri (edited February 10, 2001).]
 Posted 18 years ago
Comment Quote
About AIBreveleri -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #964 (Level 1.3)  Reply to 922
Reply Posted 2/10/2001 1:04:00 PM
Location= 
Joined=18 years ago   MB Posts=286   KB Comments=8  
Fred Daniel
 (Inactive)
Maylene, Alabama
I have been fighting that same battle over Paradox or Access. We were using Access files to store data for our sales department but found that Access has a solid limit to the amount of data that can be stores in a table. Get around the 1 gig point and it falls apart. It also lacks flexability in large scale programs.
 Posted 18 years ago
Comment Quote
About Fred Daniel -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1037 (Level 1.4)  Reply to 922
Reply Posted 2/19/2001 10:46:00 AM
Location=Maylene, Alabama  
Joined=18 years ago   MB Posts=1  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1251A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #922 Counter
2974
Since 4/2/2008

Regarding...

Linked Knowledge Base Article.

This thread is linked to the following KB article.


Mike Prestwood
1. The Future of Paradox Blog

If you have an existing Paradox system you can keep using it but you'll need to skip the Vista operating system and either stick with Windows XP or move to Windows 7. Because better tools exist, you may very well want to put a plan together now for converting to another development tool or at least understand what the future is likely to hold. If you're a power-user or researcher working with data, stick with Paradox.

Posted to KB Topic: Tool Basics
14 years ago, and updated 5 months ago
(44 KB Comments)

Blog
Nothing New Since Your Last Visit
64411
Hits

Corel Paradox / ObjectPAL Coding

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech