You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@ignite.apache.org by joseheitor <jo...@heitorprojects.com> on 2018/08/04 06:42:46 UTC

Optimum persistent SQL storage and querying strategy

Hi Ignite team,

We need to store and query retail transaction data that is expected to grow
to over 50 million records. Each basket-transaction is represented as a JSON
object with somewhat varying schema, depending on the type of transaction.
And each transaction will contain a varying amount of 'child' item entries.

What programming strategy and cluster architecture would you recommend to
optimise querying on such a persistent datastore? (preferably using SQL)

Thanks,
Jose



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/

Re: Optimum persistent SQL storage and querying strategy

Posted by Pavel Kovalenko <jo...@gmail.com>.

Hello Jose,

Did you consider Mongo DB for your use case?

2018-08-08 10:13 GMT+03:00 joseheitor <jo...@heitorprojects.com>:

> Hi Ignite Team,
>
> Any tips and recommendations...?
>
> Jose
>
>
>
> --
> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>

Re: Optimum persistent SQL storage and querying strategy

Posted by joseheitor <jo...@heitorprojects.com>.

Hi Ignite Team,

Any tips and recommendations...?

Jose



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/