本文主要是介绍mysql与redis存取数据的对比,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
因为代码中需要用到分布式,同步数据,在网上查了都说redis比mysql快,具体测试了一下,果然如此。
import java.util.Date;
import java.util.HashMap;
import java.util.Map;import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;import com.google.gson.Gson;
import com.zhaohm.redis.entity.RedisEntity;
import com.zhaohm.redis.repository.TestRepoistory;
import com.zhaohm.redis.service.MyTest;
import redis.clients.jedis.Jedis;
import org.junit.Before;
import org.junit.Test;
import net.sf.json.JSONObject;@RunWith(SpringJUnit4ClassRunner.class)
@SpringBootTest(classes=Application.class)// 指定spring-boot的启动类
public class TestMysqlAndRedis {/* *//*** Administrator* @param args*/@Autowiredprivate TestRepoistory TestRepoistory;private Log log=LogFactory.getLog(TestMysqlAndRedis.class);@Beforepublic void initUser(){}@Testpublic void getInfoTest(){long time0 = new Date().getTime();RedisEntity test=new RedisEntity();for(int i=0;i<100;i++){test.setId(i+1);test.setTrainIndex(i);test.setCarNum(i);TestRepoistory.save(test);}long time1 = new Date().getTime();System.out.println("=sql存数据==="+(time1-time0));MyTest mytest=new MyTest();RedisEntity one = TestRepoistory.findById(50);long time2 = new Date().getTime();System.out.println("之后=sql查询数据==="+(time2-time1));// 操作单独的文本串Jedis jedis= new Jedis( "10.5.133.219", 6380);Map<String,String> testMap=new HashMap<String,String>();for(int i=0;i<100;i++){testMap.put(i+"", i+"");}long time3 = new Date().getTime();JSONObject jsonObject = JSONObject.fromObject(testMap);//System.out.println("输出的结果是:" + jsonObject);//3、将json对象转化为json字符串String result = jsonObject.toString();//System.out.println(result);jedis.set("101", result);long time4 = new Date().getTime();System.out.println("\t===resid存数据----"+(time4-time3));String getResult = jedis.get("101");Gson gson = new Gson();Map<String, Object> map = new HashMap<String, Object>();map = gson.fromJson(getResult, map.getClass());String ll = (String) map.get("50");//Boolean ll = jedis.exists("50");long time5 = new Date().getTime();System.out.println(ll+"\t===resid查询数据==="+(time5-time4));}}
得到的结果:
=sql存数据===2256
之后=sql查询数据===181
===resid存数据—-217
===resid查询数据===6
这里redis存的数据时map转换的字符串,mysql是循环,所以又测了一下循环放入redis的
Jedis jedis= new Jedis( "10.5.133.219", 6380);
long time3 = new Date().getTime();
for(int i=0;i<100;i++){jedis.set(i+"", i+"");
}long time4 = new Date().getTime();System.out.println("\t===resid存数据----"+(time4-time3));
结果:===resid存数据—-76
所以,可见,redis果然是快的
这里还有个知识点:
第一:map转换为字符串以及将字符串转换为map
JSONObject jsonObject = JSONObject.fromObject(testMap);System.out.println("输出的结果是:" + jsonObject);//3、将json对象转化为json字符串String result = jsonObject.toString();
这就将testMap转换为字符串result
第二:String转换为map
Gson gson = new Gson();Map<String, Object> map = new HashMap<String, Object>();map = gson.fromJson(getResult, map.getClass());
这就将字符串转换为map
这里要用JSONObject,需要导包
<dependency> <groupId>net.sf.json-lib</groupId> <artifactId>json-lib</artifactId> <version>2.4</version> <classifier>jdk15</classifier>
</dependency>
这篇关于mysql与redis存取数据的对比的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!