Direct Query or SPICE?

Question & Answer
, , , , ,
1

Hello,

I have a database that has around 50 million rows per month. This database is occupying almost 30Gb of data on SPICE. The intention is to bring 4 months of data, and this volume will increase a lot. When do you know if it is better to use direct query instead of SPICE?

Thanks!

2

Hello July,

Each SPICE data set can be up to of 1B rows or 1TB and you can have as many as SPICE dataset as needed.

May be you could visit https://www.youtube.com/watch?v=fKlKfCUIWlg to understand more on key consideration or best practices.

Hope this helps.
thank you,
Cheers,
Deep

1 Like
3

Hi @July
its hard to tell when.
It Depends.
But 200 million rows shouldnt be a problem for SPICE. Capacity is a question about cost. But do you really need all columns or could you reduce the amount of data?
What datasource are you use?
BR

1 Like
4

Hi ErikG

I have already reduced the columns. If I group the query, I don’t have the same scenario (according to the post Analytical query vs grouped query -> calculate field - #12 by ErikG).
So, I have nothing else to do…