Re: update 500000 records with adodb.recordset resize the mdb from 140M to 2G

[snip]

> 4) I was talking about a database with 1 table because I moved this table
> out from the original mdb. but in fact, the mdb database has around 50
> tables. since this mdb database is a front end to an oracle database,
> replacing the mdb access with oracle has a big impact : moving a lot of
> access macros/stored procedures to oracle Pl/sql.

I guess the non-obvious thing, then, is why you're using any Jet tables at
all? Why not leave all the data in Oracle, and process it there? Surely
Oracle is almost infinitely more capable than Jet? (I have no experience
with Oracle, but happen to know first-hand that Jet sucks.)

-Mark


.

Relevant Pages

  • Re: Oracle BE
    ... MDB -- Access experience is critical to understanding databases. ... Access allowed me to grow into SQL Server and thus Oracle; ... Most idiot MDB developers are scared to learn a real database. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Oracle BE
    ... MDB -- Access experience is critical to understanding databases. ... Access allowed me to grow into SQL Server and thus Oracle; ... Most idiot MDB developers are scared to learn a real database. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Sign In/Out Program
    ... ADO is capable of MULTI USER that the database is open by many user at ... used DAO and ms access database for single user only. ... DAO works well with Jet. ... but mdb is a file-based database and will have the same ...
    (microsoft.public.vb.general.discussion)
  • Re: Can Access handle it?
    ... The maximum size of a Jet (MDB) database is 2GB, so at 50 MB per month, ... Follow-up questions should in general be posted to the ...
    (microsoft.public.access.externaldata)
  • Re: greater than and blank wih same field
    ... Different database programs have different dialects of SQL. ... that MDR is the SQL or ORACLE database name; that's not valid in a JET ...
    (microsoft.public.access.queries)
Quantcast