How large is your database table? The usual limitation comes from the fact that the Google Visualization API is a Javascript API, hence you can't store huge amounts of data on any Javascript datastructures (be it a google.visualization.DataTable or a plain JSON object) before the browser starts to suffer and slow down.
You may achieve different results depending on the browser/platform combination, but from my experience datasets of a few hundred thousands cells (say, a datatable with 20K rows and 10 columns) are the threshold at which the performances start to fall apart. The bottleneck depends on the browser and it may be on raw javascript parsing speed, memory consumption or DOM manipulation speed. Some browsers (for example, old versions of IE, or mobile browsers) fall apart way before that limit, and even a few thousand cells are enough to cause trouble. Another issue you might want to consider is the byte size of such table and how long it would take to transfer it to the client on typical network bandwidths. Depending on your needs, sometime is better to go for specialized datastructures tailored for your case. This one is an example of a very specific case of datastructure specialization: http://ejohn.org/blog/javascript-trie-performance-analysis/ -- R. On 23 September 2011 07:30, orkun <[email protected]> wrote: > hello > > I was wondering whether it was possible to use Google Visualization > API -data table > for a large database_table. > > Or do you recommend another one ? > > regards > > -- > 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. > > -- 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.
