Storing graphs and graph settings
Plot your data in seconds (MsSQL, MySQL, PostgreSQL, SQLite, CSV)
Brought to you by:
dbplot
Menu
▾
▴
Hi,
if I have big data graph, then "Save Permanently" of Chart Customization Form takes endless time - which I wonder about, as the settings file is just a very small xml file?
Second working with graphs I miss the ability of saving a graphs definitions like the definitions of which data field belongs to the x-axis, which to the y-axis and which to the right hand y-axis, so I could get the same arranged graph for new measurement data to come every day. The Sore Plot option is of no use here - IMHO - as this option really stores all the points in a big file, and I'm not able to use this store Plot for new generated data of the same data structure.
Also, when I set up a graph, then go back to the data register and tweak the query, then go back to the Graph --> my formerly well arranged graph has gone and I have to start all over; even in the case my altered query does not alter the above mentioned definitions of x, y, and y2 but only the values.
As I'm working with big data all this repeatedly affordable graph definitions cost lot of (useless) time.
Is it possible to get some more caching here, some graph-definition-storing?
Or did I oversee some points?
Regards
Ralf
Seems that the "Save permanently" option is designed to do what I have in mind at my (first and) "second" point in the former post. But unfortunately it does not work: besides it is incredible slow to save, only the axis-scaling seems to be used, but that's it! No chart type, no series color, no series definition at all?!
If dbplot comes with a functional way to save and reload different user chart settings, this would gave my working with dbplot a huge boost!!
Also saving and opening queries (onto sqlite-connections) would be nice. I see the buttons, but they are greyed out ...
Regards
Ralf
Ralf,
THanks for your points. All of them are valid. There is a bug with save permanently and I experienced the same thing.
About saving and opeing queries onto sqlite-connections, could the report feature help? Or maybe you can use the CREATE TABLE and UPDATE TABLE on sqlite connection to save your queries?
About the big data, I plotted ~1 million data points and the plotting time is acceptable but I want to make it faster by adding aggregration function to the data before plotting it. Is it possible to share the data too. I will not use it publicly w/o your permission? I want to know who is using the tool for serious work and what kind of work they are doing. That would encourge me to continue my work.
Pete
Last edit: DBPlot 2015-09-30
No problem Pete, these are measurement values from PLC log data. I will send you a link for download later on - together with some other maybe helpfull testing observations while using the program.
Regards
Ralf
Thanks Ralf. That would be very helpful.
Pete
Hi Pete,
sent to you already by mail.
Please confirm, that you got my mails from 30.9. and 2.10. (private) and 6.10. (via sf).
Hope we could get into contact to make dbplot even better.
Regards
Ralf
Ralf,
I didn't receive them... Could you resend them to hngodeals@gmail.com?
Thanks
Pete
Sure Pete,
in the thread "graph questions" you had a dot between hngo and deals - that's why you didn't got my mails. Hopefully now they get through.
Regards
Ralf
Ralf,
I have not received your emails till now... FYI, the "." is ignored by GMAIL server so hngo.deals@gmail.com and hngodeals@gmail.com are the same (I figured this out by accidentally sending mails to myself without the ".")
Maybe you can send me a Private Message (in sourceforge) your email and I could initialize a conversation...
It is weird why GMAIL doesn't work.. maybe there is some fake security issues that make it filter out your emails.
Thanks,
Ralf
Ralf,
I actually got both emails you sent. They are in the Spam email... I will get back to you if I have any questions.
Thanks,
Pete
Great Pete!
Regards
Ralf