Open Stack

Hello Thomas,

Storing data frames in SQL is only supported by the v1 storage interface:
https://docs.openstack.org/cloudkitty/latest/admin/configuration/storage.html
The v2 storage interface introduced InfluxDB and Elasticsearch as
replacement.

I believe the plans of the previous core team was to deprecate v1 storage
[1], so I am not sure we'll want to put lots of effort in supporting it.
However feel free to propose a patch, if it's trivial enough I don't see
why we wouldn't merge it.

[1]
https://docs.openstack.org/releasenotes/cloudkitty/stein.html#new-features

On Fri, 23 Jul 2021 at 16:25, Thomas Goirand <zigo at debian.org> wrote:

> Hi,
>
> Very fast, with only a few resources, the rated_data_frames tables
> becomes huge.
>
> I was very surprised to see there's absolutely zero index in this table.
> Isn't a "openstack rating dataframes get" querying this table, with
> tenant_id and begin / end as filters? Wouldn't the API calls be a lot
> more efficient with such indexes?
>
> Cheers,
>
> Thomas Goirand (zigo)
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstack.org/pipermail/openstack-discuss/attachments/20210723/9383b8b9/attachment-0001.html>