Hi cyclocross, Exhibit's scalability is a problem that I've tried to address with the project Backstage, although I haven't had time to make progress on that. One possible remedy is to copy the Google spreadsheet's content into Excel or some tab-separated-value file, and then use Babel to convert it into a static JSON file. Having a static JSON file avoids some preprocessing that Exhibit does on the data coming directly from Google Spreadsheets. Also, if your data contains date and numbers, it's better to express them as such in the data file rather than as strings. That'll avoid more parsing. Some other people have resolved to sectioning their data into several pages; I know that's not very desirable as you can't do searching and filtering across pages.
David cyclocross wrote: > hi folks, > > I love the exhibit / timeline code. very helpful for me. > > I used it to launch this: http://cxmagazine.com/calendar with a google > spreadsheet > > the only problem is that it's so very slow. So I desperately need to > cut its load time, by a lot and need your suggestions. on FF the > script often gives a warning (30 seconds)? I'm hoping to keep using > the google spreadsheet since it's being updated all the time by > several people. > > some possibilities? > -lazzily loading data? saw something about that but haven't figured > it out yet. > -figure out a way to paginate or pre-filter the data? didn't see a > way to do this. but I could display a month at a time or something? > pre-check some dates? > -remove the timeline view, script, code and make it a separate page (i > played with this and didn't see much gain) > -cleaning my google spreadsheet so that it doesn't have extra columns > that aren't used (didn't seem to help so I reverted) > > any others? I'd appreciate any suggestions that a very poor coder > could implement. > > thank you... > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SIMILE Widgets" 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/simile-widgets?hl=en -~----------~----~----~----~------~----~------~--~---
