Alpha Video Training
Results 1 to 4 of 4

Thread: DBF vs SQL - pros and cons ...

  1. #1
    Volunteer Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,772

    Default DBF vs SQL - pros and cons ...

    I am wondering if people can chime in with what are the considerations for using DBF vs SQL.

    It seems to em that one obvoious advantage to DBF is that it is native to a5, and is what we are familar with. However, I am very concerned about index issues that have been mentioaned elsewhere. I am wondering if MySQL would completely alleviate the index problem?

    If so, how difficult would it be to migrate an entire application to SQL?

    And certainly there are other considerations that many users would hopefully be interested in hearing about - at least I am interested!

    Gary

  2. #2
    "Certified" Alphaholic
    Real Name
    Mike Christensen
    Join Date
    Nov 2005
    Location
    Michigan U.P.
    Posts
    5,937

    Default Re: DBF vs SQL - pros and cons ...

    Hi Gary,
    Bet the reason you're not getting anyone's attention is that this has been discussed a few times and there is one thread that is very recent..check the Similar Threads located at the bottom of this one and you'll find a couple.
    Mike
    __________________________________________
    It is only when we forget all our learning that we begin to know.
    It's not what you look at that matters, it's what you see.
    Henry David Thoreau
    __________________________________________




  3. #3
    Member
    Real Name
    Steven P.
    Join Date
    May 2008
    Location
    Belgium
    Posts
    81

    Default Re: DBF vs SQL - pros and cons ...

    Hi Gary,

    The first question one needs to ask is... Do I need SQL ? Will my application become so complex overtime that SQL would definitely benefit from it ? Do you have other 'products' that rely on SQL which would interact with the Alpha application ?

    Converting from DBF to SQL should be straightforware but requires work (be it a lot depending on the complexity of the application).

    At my job I use SQL all the time because it is enterprise related. I use Alpha for my hobby project. The SQL is great when there is interaction required by so many other products for Business Intelligence purposes but would I use it for a small website ? No, not a chance.

    The bottom line: it all depends what the application would be used for.

    Cheers

    Steven

  4. #4
    Volunteer Moderator drgarytraub's Avatar
    Real Name
    Dr. Gary Traub
    Join Date
    May 2000
    Location
    Boca Raton, FL
    Posts
    2,772

    Default Re: DBF vs SQL - pros and cons ...

    Hi guys,

    Thanks for your reply. I did read the other thread, and maybe I should have posted my question there. But I was hoping to get a more thorough discussion of more of the pros and cons.

    Here are some examples of some relevant questions, most of which were not touched on in the other thread:

    1. Speed issues

    2. Difficulty in implementing SQL vs DBF, specifically with alpha - e.g. dbf has a long tested history with alpha, but what about SQL files. What issues might come up that alpha is not as well able to handle?

    3. Security issues?

    4. Speed with very large tables - e..g., let's say millions of records.

    5. Chance of corrupted indexes of SQL vs DBF

    6. What other software would be needed e.g., I run a complex WAS app with just Windows XP - would I need 2003 server or soemthing like that if the app were using SQL.

    7. What about hardware - does SQL require more powerful computer relative to DBF?

    8. Would all queries have to be rewritten or is that handled by alpha?

    And this is just for starters.

    Since alpha has been using DBF files for decades, pretty much all the issues have been worked out over time. Not so with SQL. So I was hoping to start this thread to have a place to discuss all the issues that have come up or could come up as one comtemplates beginning to migrate to SQL.

    Gary

Similar Threads

  1. SQL vs DBF
    By Alan Lee in forum Alpha Five Version 9 - Desktop Applications
    Replies: 27
    Last Post: 05-02-2008, 02:14 PM
  2. Dialog vs "Add Record Only" Grid (pros & cons)
    By jeffw85 in forum Web Application Server v7
    Replies: 3
    Last Post: 02-08-2007, 05:13 PM
  3. Embedded vs Named browses. Differences? Pros & Cons
    By Bill in forum Alpha Five Version 7
    Replies: 3
    Last Post: 06-06-2006, 07:24 AM
  4. DBF records export to SQL
    By kumargroup in forum Alpha Five Version 5
    Replies: 3
    Last Post: 04-21-2005, 05:17 PM
  5. Pros and cons using Sql Server with Alpha Five
    By William Peck in forum Alpha Five Version 6
    Replies: 0
    Last Post: 02-25-2005, 07:08 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •