Well, I don't think "ditching" SQL is the right idea. I think you should use SQL where it's spectacular - in reporting and auditing.
The normal way people use *our* product - again, not trying to advertise here - is that the data grid is the system of record; writes into the data grid get sent to ANOTHER, special purpose mirroring data grid (the "mirror service") which is responsible for writing those changes into whatever persistence engine you choose. The default persistence engine is hibernate, but you can write whatever you like. This way, you get in-memory transaction speeds; even if you update the same record many times faster than the database can update it (a situation more common than one might think), the grid is unaffected: those writes get queued up in the mirror. When it's time to run a report, well, then you use your crystal reports or BIRT or what-have-you on your SQL database, which is likely to be as current as its speed allows - which is usually "current enough" for reporting purposes. On Wed, Jan 5, 2011 at 3:33 PM, Rakesh <[email protected]> wrote: > interesting notion to ditch the SQL backend to gain more performance. > > But how would you do persistence then? You need an audit trail of > information that something happened. > > On 5 January 2011 20:26, Steven Siebert <[email protected]> wrote: >> >> You might also be interested in checking out hazelcast when comparing your >> options. http://code.google.com/p/hazelcast/ >> >> >> >> On Mon, Jan 3, 2011 at 5:13 PM, Ruby Bellavich <[email protected]> >> wrote: >>> >>> Hi all, >>> >>> Does anyone here is using GigaSpaces XAP? >>> My boss asked me to review GigaSpaces products, but from checking >>> their website I found it pretty hard to understand what is their >>> product. >>> >>> Thanks, >>> Ruby >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "The Java Posse" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]. >>> For more options, visit this group at >>> http://groups.google.com/group/javaposse?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "The Java Posse" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/javaposse?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "The Java Posse" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/javaposse?hl=en. > -- Joseph B. Ottinger http://enigmastation.com -- You received this message because you are subscribed to the Google Groups "The Java Posse" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/javaposse?hl=en.
