database engine for larg application

[illusionFinder]

hi everyone, does anybody suggest any database engine or a way to store my big data without taking much space on the pc and I can't use Mssql thanks alot:-O

[Colin Angus Mackay]

rawanrawan wrote:

big data

That depends on what you mean by "big data". Do you mean that individual elements of data are large (e.g. multi-kilobyte colums)? Or that you have a large number of rows? Or a large number of tables? Or a combination?

rawanrawan wrote:

without taking much space on the pc

It sounds like you are tring to squeeze a litre in to a pint pot. If the quantity of data is large, then the amount of disk it takes up will be at least correspondingly large.

rawanrawan wrote:

I can't use Mssql

Why is this option being discounted? Would you consider Oracle? If not, why not? ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

[illusionFinder]

thanks alot for the fast response, what I meant by "big data" is alot of rows in not too many tabels, I use access2000 and it keeps growing in size unless I make a "compact and repair" and I want to stop doing that and I can't use sql cuz it takes space of the pc -- modified at 9:09 Monday 27th February, 2006

[Colin Angus Mackay]

rawanrawan wrote:

it keeps growing in size unless I make a "compact and repair" and I want to stop doing that

I would guess all database systems will require something like that. If they do it automatically as it goes along then data access will be very slow. The reason it keeps growing is that it is an expensive (i.e. time consuming) operation to compact the database. Some database systems, like SQL Server, allow you to schedule tasks so that it occurs automatically at a time that is suitable. e.g. if it a system used during office hours only, then you can schedule it for the middle of the night. ColinMackay.net Scottish Developers are looking for speakers for user group sessions over the next few months. Do you want to know more?

[Guffa]

The Access drivers also takes space, but you don't see that as they are installed by default with Windows. Any competetive database solution that you choose will take space on the pc. You could for an example use the text file data driver that is also pre-installed, but you would lose very much in performance. Compare the space that the database engine will take up against what you win by not having to "compact and repair" the database continously. An alternative to MS SQL that might be a bit more light weight would be MySQL. Compare the system requirements. --- b { font-weight: normal; }