我想要20000条记录的数据库 [英] I want database of 20000 records

问题描述

我想要一个数据库，其中包含至少20000到30000条记录，这些记录可以是任何购物卡记录，例如产品ID，名称，奖品或任何客户信息记录，例如客户名称，电子邮件，年龄(imp).对于我的项目，我想找出通过应用索引与不应用索引来搜索数据之间的区别，然后我想从用户搜索pattern.ie中找出索引.当任何用户进入网站时，他会搜索哪种模式，以便通过让用户查询，我想找出数据库中数据搜索的最佳索引.使用查询工作量的高维数据库的索引建议.如果您有任何帮助，请重播.

I want a database which contain min 20000 to 30000 records which may be any shopping card record like product id,name,prize or any customer info record like customer name,email,age(imp)like this.I want this database for my project I want to find out difference between searching data by applying index & without applying index & then I want to find out index from users search pattern.ie. when any user comes on the website which pattern he search so that by getting users query i want to find out best index for data search in database ie. index recommendation for high dimensional database using query workload.If you have any help please replay me.

推荐答案

您不太可能会找到现成的示例数据库那么大:您可能需要自己创建一个并填充它.

It is very unlikely that you will find a ready made sample database of that size: You will probably have to create one yourself and populate it.

同意OriginalGriff.我建议从以下步骤开始.

1)在SQL Server 2008中设计和创建数据库和表.
2)在C#.Net中编写一个简单的应用程序，该应用程序将遍历for循环，并将在数据库表中插入尽可能多的记录.
3)然后继续使用索引进行性能测试.

Agree with OriginalGriff. I would recommend below steps to start with.

1) Design and create Database and Table in SQL Server 2008.
2) Write a simple application in C#.Net, which will traverse through for loop and will insert as many as records in your DB Table.
3) Then continue with your Performance Test using indexing.

这篇关于我想要20000条记录的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！