在 Web 应用程序中存储和显示大量基于时间的调度信息
我的项目涉及存储大量的多日事件。
然后，数据需要显示在网页上的大表格中，类似于日历类型的应用程序，但具有更精细的细节。但是，显然我的页面加载速度越快越好！
基本屏幕可能会显示 10 行主题和 10 列日期。
每天可以分成半天的部分。每半天，可能有 3 或 4 个活动，每个活动可能有一个状态，每个主题可能可用或不可用等。
显然，我不想执行 100/200 数据库查询来总结每个活动和主题半天。
1.是否存在存储、汇总和显示大量基于时间的信息的应用程序示例？
2.哪些应用程序可以有效地显示此类复杂数据
My project involves storing large amounts of multi day events.
The data then needs to be displayed in a large table on a web page, similar to a calendar type application but with finer detail. However, obviously the faster my pages can load the better!
A basic screen might display 10 rows of subjects and 10 columns of days.
Each day can be split into half day segments. Each half day, there may be 3 or 4 activities, each activity may have a status, each subject may be available or unavailable etc.
Obviously, I don't want to perform 100/200 database queries to summarise the activities and subject for each half day.
1. Are there existing examples of applications which store, summarise and display large amounts of time based information?
2. What apps display complex data such as this effectively
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果我正确理解你的问题，你想要一个没有事件之间依赖关系的甘特图的变体。
我的建议是查看谷歌图像上各种甘特图的图像，看看这是否是您正在寻找的。
为了回答您的第一个问题，日历应用程序通常不会将多日事件存储为数据存储中的多行。如果您有开始日期和结束日期，应用程序可以计算中间天数。
If I understand your question correctly, you want a variation of a gantt chart without the dependencies between the events.
My suggestion would be to look at images of various gantt charts on Google images and see if that's what you're looking for.
To answer your first question somewhat, calendar applications don't usually store multi-day events as multiple rows in a data store. The application can calculate the intermediate days if you have the start and end date.