当前位置:网站首页>考试系统进入试卷优化思路
考试系统进入试卷优化思路
2022-04-23 19:14:00 【音神】
在日常中,会有大量的用户在线上进行考试,进入试卷、答题、提交试卷都是使用人数最多的环节。
痛点
用户多进入试卷加载时间过长,系统响应慢;很多人同时提交试题和提交试卷总修改数据库,数据库承受压力过大。
优化思路分为三点
1.程序层面的优化
2.数据库层面的优化
3.增加服务器的配置
进入试卷
1.进入试卷可以将数据放入缓存,比如使用Reids。
2.对数据表字段添加索引。
3.预生成用户试卷静态页面。
提交试题
1.每次提交试题可以将数据放入缓存,比如Reids缓存。
提交试卷
1.提交试卷时可以将试题的数据和缓存的数据打印到日志中,防止出错时数据无法找回。
2.建议在最后提示试卷时,整体再提交一次试题的答案,防止试题答案丢失。和缓存中的数据进行比对。缺少的数据,使用整体提交的数据进行填充。
3.最后将缓存中的试题、和试卷数据,放入消息队列,进行异步执行。
版权声明
本文为[音神]所创,转载请带上原文链接,感谢
https://blog.csdn.net/gc666888/article/details/124364481
边栏推荐
- C1000k TCP connection upper limit test 1
- SQL常用的命令
- Encyclopedia of professional terms and abbreviations in communication engineering
- Yyds dry goods inventory stringprep --- Internet string preparation
- 坐标转换WGS-84 转 GCJ-02 和 GCJ-02转WGS-84
- Raspberry pie 18b20 temperature
- The type initializer for ‘Gdip‘ threw an exception
- Use of fluent custom fonts and pictures
- [记录]TypeError: this.getOptions is not a function
- [report] Microsoft: application of deep learning methods in speech enhancement
猜你喜欢
Why is PostgreSQL about to surpass SQL Server?
该买什么设备,Keysight 给你挑好了
Raspberry pie uses root operation, and the graphical interface uses its own file manager
[today in history] April 23: the first video uploaded on YouTube; Netease cloud music officially launched; The inventor of digital audio player was born
ArcMap publishing slicing service
2022.04.23(LC_714_买卖股票的最佳时机含手续费)
Audio signal processing and coding - 2.5.3 the discrete cosine transform
Keysight has chosen what equipment to buy for you
arcMap 发布切片服务
8266 obtain 18b20 temperature
随机推荐
binlog2sql 工具安装使用及问题汇总
Wechat applet part of the mobile phone Preview PDF did not respond
The difference between ordinary inner class and static inner class
Openlayers 5.0 thermal diagram
Is it safe to open an account in Bohai futures.
Parsing headless jsonarray arrays
MySQL statement
2022.04.23(LC_714_买卖股票的最佳时机含手续费)
Minesweeping II of souI instance
SSDB基础2
微搭低代码零基础入门课(第三课)
I just want to leave a note for myself
该买什么设备,Keysight 给你挑好了
Redis common interview questions
Some speculation about the decline of adults' language learning ability
Methods of nested recycleview to solve sliding conflict and incomplete item display
Solve the problem of invalid listview Click
The flyer realizes page Jump through routing routes
[record] typeerror: this getOptions is not a function
Quick start to static class variables