Are you reading from multiple database tables in your MySQL database for each visualization or the same one just displaying the data differently?
If all are reading from the same MySQL database table then I'd recommend storing them into a google datatable and working with it from there. If your doing multiple queries or using multiple tables, then I'd handle it similar to the way you would do for a single table. Read the information, toss it into a google data table, then run the next query, etc. Not sure if you were simply using queries to fetch your data or how you were doing it before as you didn't go into too much detail, but it shouldn't be too much different than fetching information for a single data, just remember the more times you have to hit your database the more of a performance hit its going to take, assuming the queries are substantial. You could limit the hits by reducing the queries on the database and storing them in the google data tables and then working with them from there. On Thu, Jul 1, 2010 at 6:15 AM, Jinji <[email protected]> wrote: > > > On Mon, Jun 28, 2010 at 8:12 PM, MartinOShea <[email protected]>wrote: > >> Hello >> >> I want to load 4 or maybe 6 visualisations of different types on to a >> single page via a servlet or JSP which will serve as a welcome page to >> my application. To reduce bandwidth and time, I want each >> visualisation to contain only the most recent data read from a MySQL >> database and this will be written as Javascript to the JSP which will >> then call the Google Viz API. >> >> Getting data from the database for one visualisation per page is >> something I've done before but is there any advice you can give me >> regarding populating multiple visualisations in one go? >> > > Advice on what area are you interested in? This should work. > > An alternative is for me to may be to use images on the page which >> will display the visualisations. I see the areachart, barchart, line >> chart and pie chart are available as images but can you let me know >> the status of the scatter chart and column chart? >> > > Look at http://code.google.com/apis/chart/docs/gallery/chart_gall.html for > image chart types. I can see column chart (under bar chart) and scatter > chart there. > > >> Any help would be much appreciated. >> >> Martin O'Shea. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google Visualization API" group. >> To post to this group, send email to >> [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<google-visualization-api%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/google-visualization-api?hl=en. >> >> > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" 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/google-visualization-api?hl=en.
