best search in mdb for big data

Question

I have created a dictionary for English to Kurdish and I saved my data in .mdb access file, my data are more than 78,000 words. Please can anyone help me to make a quick search? I'm using this query for search "SELECT english FROM table WHERE English LIKE '" +text Searchlight. Text+"%'";

What's the problem with that query? – Dan Bracuk Nov 12 '15 at 17:33 — Dan Bracuk, Nov 12 '15 at 17:33

score 1 · Accepted Answer · edited May 23 '17 at 12:24

If your query is:

SELECT english
FROM table
WHERE English LIKE '" +text Searchlight. Text+"%'"

Then I'm a little confused. Access generally uses * as the wildcard for searching rather than % (which is the SQL standard). Because the LIKE pattern does not start with a wildcard, many databases will use an index (if available) for this query. I don't know if MS Access has this optimization.

In any case, you seem to be going down a path where full text search is beneficial. If so, I think you have the wrong tool for the job. MS Access doesn't support full text search. I would suggest that you use a database that does (obvious choices are SQL Server Express, Postgres, and MySQL, all of which are free). By the way, all three of these do use an index for LIKE, when the pattern does not start with a wildcard character.

If you decide to use SQL Server Express, this answer should be helpful for the installation.

Gordon Linoff You are right about * and % it was my fault. – Yousif Garabet Nov 15 '15 at 05:48 — Yousif Garabet, Nov 15 '15 at 05:48

best search in mdb for big data

1 Answers1