Text search compare MySQL vs PostgreSQL vs MongoDB performance analyze.

preview_player
Показать описание
How to search something in text in your database and where it would work faster? Search by LIKE operator and search by FULLTEXT INDEX.
  1. MOSHENSKY
  2. Fulltext search
  3. like
  4. database
  5. postgresql
  6. mysql
Рекомендации по теме
Text search compare 0:05:30

Text search compare MySQL vs PostgreSQL vs MongoDB performance analyze.

Database Full Text 0:01:30

Database Full Text Search Explained

How to Query 0:08:05

How to Query MySQL Full Text Search Using MATCH and AGAINST

Episode #386 - 0:01:33

Episode #386 - MySQL FULLTEXT Search | Preview

Full Text Search 0:18:13

Full Text Search PostgreSQL

Full Text Search 0:03:09

Full Text Search In MySQL: 8 Things (3 Min) You Need To Know

MySQL vs MongoDB 0:05:30

MySQL vs MongoDB

PostgreSQL Full Text 0:14:12

PostgreSQL Full Text Search Tutorial

Rockset Acquired by 0:43:53

Rockset Acquired by OpenAI: What's Next for Its Users?

15 futuristic databases 0:08:42

15 futuristic databases you’ve never heard of

Mysql Full Text 0:09:24

Mysql Full Text Search por Michael Douglas - 7Masters MySQL

Database Speed Showdown: 0:10:32

Database Speed Showdown: SQL, NoSQL vs. PostgreSQL Performance Comparison

What is Full 0:03:36

What is Full Text Search in SQL Server Where do you need to use this feature

MySQL vs PostgreSQL 0:02:17

MySQL vs PostgreSQL - Differences and What to Choose

Vector databases are 0:03:22

Vector databases are so hot right now. WTF are they?

How do SQL 0:12:12

How do SQL Indexes Work

Full Text Search 0:00:44

Full Text Search Index In #laravel

Querying, Indexing, and 0:10:20

Querying, Indexing, and Full-text Search in Redis

How to Query 0:11:30

How to Query SQL Server Full-Text Search Using CONTAINS and FREETEXT

Searching for text 0:11:01

Searching for text in SQL Server: CHARINDEX and PATINDEX

SQL vs. NoSQL 0:04:01

SQL vs. NoSQL Explained (in 4 Minutes)

Full-Text Search Throwdown 0:57:43

Full-Text Search Throwdown

Full-text Search with 0:01:36

Full-text Search with Redis

Комментарии
Автор

PostgreSQL vs MongoDB - full text search? use ES. If you want compare try to compare save JSON Object in both DB and search JSON.PATH PG12 vs MONGODB. Then try to make LB in PG and MongoDB and see what's looks better. Where is the sql script and codebase that use for compassion? No one can reproduce this research

namefn
Автор

I have a 30gb db mostly text... using mysql it takes sooo long to load even with a powerfull server, I tried to use lucene (solr) but it wasn't working...
So now i'm gonna try meilisearch db instead of mysql... I hope it will be fast enough, if you have any suggestions of how I could search fast in this 30gb db...
(its id, author_id, title, message, date_creation, date_deletion)
I wanna search through message or title... this is really really hard to do to have good perfs

vostfrguys
Автор

you don't think you queries are wrong with x25 performances differences between MongoDB and MySQL? Using Regex sounds expensive, why not building your query with MongoDB native methods as you did for MySQL

nielsdominguez