MySQL: Where to find sample database with large text content?

Question

For a college assignment I need to run an experiment related to MySQL. I have chosen to compare the performance of LIKE to MATCH AGAINST in the context of searching text fields.

The MySQL sample "Employees" DB was recommended to us but it doesn't really have any text fields with long text values. I'm of the opinion that i'd need something along the lines of a paragraph of text for each record to give decent results. I guess something like a paragraph about each employees background would be ideal. BUT, there are approximately 300k employees in that database.

Also, i'm guessing that the text values would want to be pretty distinct for each employee. Couldn't just use the same few for all employees.

Am I right in my assumptions and if so. Are there any other sample databases out there that would suit me?

Any ideas?

I just came across a similar question in the right hand pane. One answer suggests using the wikipedia dumps. Checking out now. — jim, Nov 24 '11 at 14:16
@BenSwinburne Hi, yes, I did.. Went with the Wikipedia dumps.. Lot's of text there. Thanks :) — jim, Dec 12 '11 at 15:31

score 0 · Answer 1 · edited May 23 '17 at 11:44

0

You might want to look at this previous post. One of those dataset HAS to be in mysql if not you can use www.talend.com to load it into your application.

Where can I find sample databases with common formatted data that I can use in multiple database engines?

edited May 23 '17 at 11:44

Community

1
1

answered Nov 24 '11 at 14:19

Stainedart

1,929
4
32
53

Ben Swinburne · Accepted Answer · 2011-11-24T14:42:25.890

0

You might try any of the following links

edited Nov 24 '11 at 14:42

answered Nov 24 '11 at 14:21

Ben Swinburne

25,669
10
69
108

MySQL: Where to find sample database with large text content?

2 Answers2