Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Hosting A5 data driven websites

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Hosting A5 data driven websites

    I am thinking about an A5 data driven web application.

    I have a remote server for websites and this has 500Mbytes of ram

    It seems that if I use A5 for data driven web apps I may need to hire an additional remote web server to operate the database.

    My local upload speed is not sufficiently fast .2 .4Mbs so it will be a case for hiring.
    Database posibilities seem to be
    access
    A5
    Sql 2005 express version
    I wonder if anyone can give me pointers on this please
    Thanks
    John

  • #2
    Re: Hosting A5 data driven websites

    mySQL offers the best of both worlds, highly compatible with Alpha5 (and you can generate all tables from existing dbfs) and faster/better suited for multi user access than dbf files.

    SQL Server has some quirks to do with row locks that have made it a bit tricky for this sort of thing (even when you have a read only view, it seems to temporarily lock the rows you view and this can cause problems).

    You are right about the upload speed, although depending on your situation if you have a server already, it may be cheaper to just get a better broadband package?

    Comment


    • #3
      Re: Hosting A5 data driven websites

      Thanks NoeticCC
      I have looked at mySQL in the past, but it seems very unstructured and difficult to work with. I expect is OK when you know how, but from memory it was like working in dos. Perhaps there are ways around this?

      Unfortunately I cannot get a faster broadband package here. I have tried but evidently the BT substation is the problem.

      Would 500 mbytes ram be sufficient for the A5 Server with access or mysql or would speed be a problem?
      Regards
      John

      Comment


      • #4
        Re: Hosting A5 data driven websites

        500mb may be a bit tight, but it does depend on what you do with it. We have one with many pages and frequent access that serves up PDF proofs and sends emails, generates images from different formats etc. etc. with 1 GB memory and it is generally very fast and copes very well.

        It might be better if the mySQL database was on a different server, this would also help spread the load. Access would have the same downside as DBF files and none of the positive points, if you are going to use something other than DBF I would really go for mySQL.

        Comment


        • #5
          Re: Hosting A5 data driven websites

          Just use the DBF tables that come with Alpha. 90% or so of us are doing just this.
          Steve Wood
          Join the ALPHA DEVELOPERS NETWORK
          There is no Cloud. It's just someone else's computer.
          Web - Mobile - Hosting - Products - Frameworks - Developer Resources
          AlphaToGo | IADN (100% Alpha Anywhere Websites)

          Comment


          • #6
            Re: Hosting A5 data driven websites

            Thanks
            Its good to hear the differing views.

            So for fairly low usage would the present 500Mbytes and the A5 Server be able to manage?

            Comment


            • #7
              Re: Hosting A5 data driven websites

              I don't know where my buddy Kevin is these days, but he liked to show off his A5V7 HVAC ordering system with 500K records on a PIII with 256K. It was slow, but it worked fine. A web app doesn't do anything unless someone just pressed a button somewhere. The rest of the time it sits idle. I ran a server with normal ADSL, back when it was under 1MB, and it ran fine for the 10 or so casual users. The point is, build it, deploy it on what you have, then evaluate if you need more.
              Steve Wood
              Join the ALPHA DEVELOPERS NETWORK
              There is no Cloud. It's just someone else's computer.
              Web - Mobile - Hosting - Products - Frameworks - Developer Resources
              AlphaToGo | IADN (100% Alpha Anywhere Websites)

              Comment


              • #8
                Re: Hosting A5 data driven websites

                This may help.

                I have a web site hosted at ZebraHost on a VPS with 1 gig of memory. Clive has done a lot of work lately to optimize the VPS for Alpha, and it is working well (and fast).

                On that site, I have Alpha V9, Alpha WAS, MySQL Version 5.1, and the MySQL Query Browser. I am able to remote desktop in, open them all up and use them all at the same time for development. The speed isn't the greatest, but I can live with it.

                When that application is finished, I plan to host it on a dedicated server at ZebraHost with 2 gig memory, but I expect it to be a heavy use site.

                Personnally, I think 1 gig is the sweet spot for remote servers. I've moved all my clients to that, and they are happy they did. I would not even try 500M.

                Pat
                Pat Bremkamp
                MindKicks Consulting

                Comment


                • #9
                  Re: Hosting A5 data driven websites

                  John Hardy,

                  My years of experience with hardware always tells me to over do it a bit.
                  However today with prices being what they are being concerned with Ram
                  is crazy. I have a 24/7/365 intranet running on an XPPRO with 4gig of ram and the box cost like $800-900 (HP).

                  DB is native dbf's records are in the mid 20-50,000 and performance is great. I started with dbf and told the customer that if we see a performance issue down the road we would have to go to something else like MSSQL. Why spend the money on having to setup a SQL server etc....

                  We are now after a 1 year of transactions are archiving "History" so the main working files are fresh......

                  I had made mistakes on different pages/grids that inhibited performance but once I understood those mistakes Staying away from them the site is quite fast, considering they are using a DSL for 2 office to access the intranet.

                  Nicholas
                  Nicholas Wieland
                  LedgerSuite.com Corp
                  nnw@edfi.net
                  http://www.ledgersuite.com

                  Comment


                  • #10
                    Re: Hosting A5 data driven websites

                    Many thanks for all the excellent replies I can see the way forward a little more now. I just did not wish to land up with nowhere to go.
                    So thanks again
                    John

                    Comment


                    • #11
                      Re: Hosting A5 data driven websites

                      Originally posted by JH10 View Post
                      I have a remote server for websites and this has 500Mbytes of ram
                      With memory priced at $50 for 512 mb, I consider 1 gb the minimum to run windows (without Alpha)

                      2 gb is much better..... 4 gb is sweet.. It's money well spent.
                      Al Buchholz
                      Bookwood Systems, LTD
                      Weekly QReportBuilder Webinars Thursday 1 pm CST

                      Occam's Razor - KISS
                      Normalize till it hurts - De-normalize till it works.
                      Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
                      When we triage a problem it is much easier to read sample systems than to read a mind.
                      "Make it as simple as possible, but not simpler."
                      Albert Einstein

                      http://www.iadn.com/images/media/iadn_member.png

                      Comment


                      • #12
                        Re: Hosting A5 data driven websites

                        Thanks Al
                        for the good guidance

                        Comment


                        • #13
                          Re: Hosting A5 data driven websites

                          You have received some great advice/posts.

                          My two cents:
                          The DBF route is a great, inexpensive route.
                          But, IMHO, if I had any more than a few people updating data at the same time, I'd rather hand that job over to a real DB engine - mySQL or SQL Server.

                          I'm biased towards SQL Server, for these reasons:
                          - It's very solid
                          - It's extremely easy to administer
                          - SQL Server Express is free, and it can take you further, with more
                          reliability, and better performance, than DBFs or an Access file.

                          We have been using SQL Server internally for many years. We don't have a single instance of unusual hangs, corrupted/lost data, or hassle of any kind.
                          We do no special maintenance on the databases, beyond daily automated
                          backups.

                          For us, it's just been - working and working.
                          Frank R

                          Comment


                          • #14
                            Re: Hosting A5 data driven websites

                            Thanks Frank
                            Good to hear of your experience.
                            Gris to the mill.
                            Cheers
                            John

                            Comment

                            Working...
                            X