We help IT Professionals succeed at work.

DataBase for Auditing on large files

pessana
pessana asked
on
Medium Priority
286 Views
Last Modified: 2012-05-04
I need a DB server able to use large tables (up to 1.7Gb) for auditing.
I don't need to write a program, I only have to write queries, 'cause in this part of my project I need to write down a method for "reading" results.
MS Access is the ideal tool, but it has a 1Gb limit, we tried to divide tables in smaller ones, but complexity and elaboration times are unaccetable.
Oracle could be a good choice, but is too expensive for this project budget, does anybody knows a solution?

P.S. We use notebooks and we don't have access to servers

Thanks


Ing. Enrico Pessana
A.S.P. S.p.A.
Comment
Watch Question

Actually, MS Access is limited to 2G for the Database size if you go to Access 2000 or above.

MySQL is free.  It's table limitations are here:
http://www.mysql.com/doc/T/a/Table_size.html

dill

Commented:
You can also get free Oracle (Personal Oracle) for development and testing purposes if you become a registered member of OTN.  For $400 a year, Oracl will mail you the latest versions of the Track (I suspect it will be Windows for you) that you become a member of.
Brendt HessSenior DBA
CERTIFIED EXPERT

Commented:
Also consider PostgreSQL.  It is free, opensource, and has some features not in MySQL (as MySQL has some that PostgreSQL does not).  

Commented:
InterBase
pessana,

In an effort to help clean up the open questions, I am going thru old questions that I have participated in.

This question needs closed either by deleting it or PAQing it.

Please do one of the following:
1. Award points.  If a point split is necessary, post a zero point question in Customer Service specifying how to split them and a link to the question.

2. If you felt any help was worth points, then post a zero point question in the Customer Service area, with a link to the question, asking for points to be reduced then award them.

3. Otherwise, just delete it.

Thanks,
dill

Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
Commented:
Question has been closed as per recommendation

JGould-EE Moderator

Explore More ContentExplore courses, solutions, and other research materials related to this topic.