I have 3 facilities that store operational data - a month worth of data for 1 facility is 200-300 MB.
Currently using mulitple Access databases to store and query the data. Due to the limits of Access databases, it just can't keep up with processing and are also a pain to switch back and forth between all the databases.
I am looking for advice/opinions on Oracle vs Sybase.
All I need is to store the data after running through a Java parser, then be able to run fairly simple SQL scripts - such as counting records based on criteria (ie. how many records for 2/1/2002).
Advice?
Thanks in advance for your help!
