MS Access vs Oracle

Results 1 to 5 of 5

Thread: MS Access vs Oracle

  1. #1
    Tony Guest

    Default MS Access vs Oracle

    Hey List,<BR><BR>I am wondering if anyone can tell me which would be the better or maybe the only option. <BR><BR>I am going to have to design a database that may house up to 50,000 entries. It will house details for a search engine for people in this database. I just wanted to know if anyone can tell me which database would be the best option (also having efficiency and robustness in mind). I already have MS Access 2000, I will need to purchase Oracle 8 if I need to design in Oracle. <BR><BR>Anyway Thanks in Advance.<BR><BR>-Tony

  2. #2 Guest

    Default RE: MS Access vs Oracle

    I use Access extensively as a web database and I don&#039t think that 50000 records will phase it. Just design your queries carefully, and set them up in Access, not in your ASP. In ASP open a recordset from the query in access rather than try to formaulate complex queries in your code. Make sure that the query returns a small dataset and you should be right. <BR><BR>The other issue is whether your hosting company supports Oracle. If they do and the cost of using it is reasonable then use it, as it will probably be more robust and efficient.

  3. #3
    Tony Guest

    Default RE: MS Access vs Oracle

    So what would be the limitations of Access 2000???

  4. #4
    Join Date
    Dec 1969

    Default RE: MS Access vs Oracle

    It doesn&#039t scale very well. If you&#039re expecting hit rates high enough to generate really concurrent database access then Access doesn&#039t scale past a handful of *concurrent* connections.<BR><BR>Still, you need a lot of hits or narrow spikes to get real concurrency.<BR><BR>Dunc

  5. #5
    Tony Guest

    Default RE: MS Access vs Oracle

    Ah Thanks Duncan,<BR><BR>Understood!!! hehehe... (I&#039m only a university student) hehehe

Posting Permissions

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