Some thoughts: > Without the WHERE, it works fine, so the rest of the code is okay. Is > there specific Google spreadsheet syntax that I should be using?
If there are, that would be one of the drawbacks of this method ;) Using Google Spreadsheets, other than binding you to potentially special syntax, means you are specifying your query client-side, where you may instead want to specify the query parameters server side. I believe this also implies the spreadsheet is accessible by the client, too, but I'm not sure. This may not be an issue, but it's worth keeping in mind. > From my understanding, > with MySQL, I'd have to recreate the data table in the html then run > it through google visualizations You would have your MySQL query return the rows and columns you want, and then have your server side code generate the right javascript to define the table. The GVIZ Team has documented a few different ways of doing this. One way is described here: http://code.google.com/apis/chart/interactive/docs/php_example.html Another is here: http://code.google.com/apis/chart/interactive/docs/dev/implementing_data_source.html They each have their own pros and cons; it's best to look over them to see which makes more sense for your project. > Are there any speed issues relating to the > MySQL approach if I'm drawing a large data (more than 2500 data > points) then passing it through Visualizations? Once the data has been sent to the browser, where it came from (MySQL vs a Google Spreadsheet) doesn't really matter. What matters is how complex your visualizations are, as well as how you are consuming the data (for example, the above two links show two different ways of getting data into the tables). That happens client-side, which affects rendering performance. If you want to see how the visualizations perform with 2500+ data points, it's best to make a few test cases and try them out to see. Note that you need to test in different browsers, since JavaScript performance varies from browser to browser (even from version to version). From my experience, no single browser is fastest or slowest in everything, and the variance can be significant. That's important to keep in mind; it's one of the "challenges" of building js applications. It's also one of the headaches ;) > Am I missing any > functionality by using Google spreadsheets instead of the PHP+MySQL > approach? As far as visualizations go, I don't think PHP/MySQL vs GOOG spreadsheets matters. These choices are really server-side choices. You should be able to switch from one to the other without changing the performance of the visualization part (though the server-side performance will naturally change). My general advice is to pick standard technologies as much as possible, and be careful when using vendor specific tools - build the right amount of abstraction around them so that you can switch implementations without a major headache, but still keep your development time fast. Using Google Spreadsheets has some benefits - they are spreadsheets that non programmers can edit, fast development time, etc, but they have some disadvantages. There are pros and cons with PHP/MySQL, too (standard technologies, but you need to create and manage databases, write code or manage a framework, need a server for the data, etc). Test performance a lot, especially keeping in mind the browser differences I talked about. I suggest testing Chrome, IE, Firefox, and Safari. Running your app on an iPad or Blackberry, or Android device? Test there, too. Each of these browsers and devices will perform differently, especially with large data sets. Even the type of visualization matters (how many lines in your chart? how many slices in your pie? labels? tables with or without pagination? any animations? etc). In general, it's not hard to get started, but to make things perform, it takes a lot of testing and fine tuning... Good luck! -- 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.
