----- Original Message -----
From: nathanelrick
To: firebird-support@yahoogroups.com
Sent: Wednesday, March 28, 2012 8:04 PM
Subject: [firebird-support] Re: Firebird and sharding ? - Email found in
subject


>> But realize that there are very real problem with those types of
>> >analysis solutions when dealing with OLTP databases -- otherwise there
>> >would be solutions
>>available (that don't have license fees that are >more than the total
>>sending cost of sending a child to a US Ivy League >school for 4 years).

>yes i understand, but now with my 50 millions rows table i start to meet
>the limit of firebird where a simple prepare can take around 1 s to 1 min
>dependantly the
>charge of the server (see my previous post). next year it's will be around
>100 millions rows and i will have no solutions ... this why i start to
>thing about sharding in
>an easy way, in a way out in fact

I am not sure what your purpose of your DB is, but if I recall correctly you
did something with session data in this big table. Perhaps for that purpose
the use of another database like one of the noSQL database is better.

I read some article shortly ago about a big site with a lot of trafic. They
migrated their session data to a noSQL DB (I believe MongoDB) because of the
nature of the data. They gained a lot of performance doing that.

The concept of these noSQL databases is not clear to me yet (I am not a DB
specialist) but I do read a lot about sites migrating parts to these kind of
database from a former relational database like Firebird. One of the
examples mentioned often is historical data that is moved to these noSQL
databases.

Perhaps you should take a look at that too.

Benno