search   285544

« earlier
does what it scene jobs (and design too)
art  jobs  search  design  resources 
7 hours ago by inrgbwetrust
Don’t Waste Your Time With MySQL Full-Text Search – Hacker Noon
It’s executed in 50 seconds, which makes it unusable…

Please note this is the same query as above, with only one additional condition (id > 10000000). Moreover, the query doesn’t return any rows, because the additional condition excludes all rows (all IDs are below 10,000,000).

Why is it so slow? It’s because the term “commercial” used in my query is common (~300,000 documents contain the term) and because MySQL is not good at merging indexes. Basically, MySQL uses the full-text index to lookup for the term “commercial”, and then it does a kind of nested join to lookup for the 300,000 rows and check the condition on id. The former is very quick, but the latter is extremely slow.

It would be really great for MySQL to be able to combine multiple index using an in memory bitmap. This would make the built-in full-text search a lot more useful. In the meantime, I have to find an alternate solution.

If you have any idea about how to solve this without switching to another database engine, please reach out to me.
MySQL  SearchTechnologies  Search 
12 hours ago by cnk
Introduction to Web Archive Discovery
A walk through of loading WARC data into Solr and then viewing the index with Shine and Warclight...all in your browser! From @anjacks0n.
webarchive  search  solr  warc 
16 hours ago by edsu
ACM Digital Library
The ACM Digital Library is a research, discovery and networking platform containing:
The Full-Text Collection of all ACM publications, including journals, conference proceedings, technical magazines, newsletters and books.
A collection of curated and hosted full-text publications from select publishers.
The ACM Guide to Computing Literature, a comprehensive bibliographic database focused exclusively on the field of computing.
A richly interlinked set of connections among authors, works, institutions, and specialized communities.
ebooks  library  computer_science  tech  database  reference  search 
yesterday by dicewitch
BurntSushi/ripgrep: ripgrep recursively searches directories for a regex pattern
ripgrep recursively searches directories for a regex pattern - BurntSushi/ripgrep
tool  search 
yesterday by HusseinMorsy
Does Paid Help Organic Search? Yes And No

by for

Search  PPC  from twitter_favs
yesterday by pamneely

« earlier    

related tags

_todo  academia  academic  admin  advertising  agency  aggregator  alternatives  and  android  angular  annoyance  api  app  apps  archive  art  article  backup  beam  big-data  bing  bitcoin  blog  blogspot  book  bookmarks_bar  books  bookstore  brand  browser  c++  c  career  central  certificate  checker  checkjetaal  cli  clipboard  cloud  code  command  commercial  community  companies  computer_science  console  creative_commons  crypto  crystal  css  ct  curated  d&d  d8  data  database  debug  decentralization  design  desktop  development  directory  dois  domain  dotnet  download  drupal  ebook  ebooks  elixir  emacs  email  encryption  engine  extensions  facebook  file  files  filesystem  filter  filterbubbles  find  firefox  fix  folder  font  forwarding  framework  free  fzf  github  gmail  go  golang  google  googledocs  hadoop  haskell  help  hiphop  homophily  hosted  how-to  howto  hyperlinks  ie11  images  index  indexing  indieweb  inspiration  interface  intro  ios  japan  japanese  java  jfall  job-board  job  jobs  js  keywords  kotlin  laptop  library  light  lightning  list  log  mac  mapreduce  market  marketing  masking  messaging  meta  metadata  metasearch  misreading  ml  mobile  movies  multiplatform  music  mysql  network  neuralnets  neutrino  new-web  news  nodejs  noncommercial  notes  novemberochtend  online  opensource  organization  outlook  package  paper  pathfinder  people  persistence  php  plugin  plugins  ppc  print  privacy  productivity  profile  profiling  programming  protocol  python  react  recruiting  reference  regex  registration  related  research  resource  resources  resume  rss  ruby  rust  scai  scala  science  search_engine  searchengine  searchtechnologies  sec  security  self  self_hosted  seo  serp  service  share  shell  shopping  simplicity  social  software  solr  source  spam  spreadsheets  ssl  storage  streaming  swift  syntax  sysadmin  tagging  tags  tech  technology  tls  tool  toolkit  tools  totwitter  tutorial  twitter  ukiyo-e  unix  utility  ux  video  vim  wallet  warc  web  webarchive  webdesign  webmaster  widget  widgets  windows  woodcut  wordpress  youtube  yunohost 

Copy this bookmark: