Azure search or full text index? -

-

data in sql azure, have existing webapi expose data odata. issue client want make call filters substring query on few columns, making performance slow. debating @ point whether use full text search index or use azure search service, thoughts please?

some of considerations , tradeoffs between hosting search in azure search vs. using sql server fts captured here.

as pointed out above, azure search can index in-database data - see connecting azure sql database azure search using indexers.


Comments

Post a Comment

Popular posts from this blog

ZeroMQ on Windows, with Qt Creator -

-
i have installed zmq link given below on windows 7. http://zeromq.org/distro:microsoft-windows 1) have c++ project in qt-creator , i'm using zmq c++ binding (zhelpers.hpp etc). 2) have added .lib installed zmq folder qtcreator 3) while compiling, compiler looks _imp__zmq_verion, in .dll files present in .lib have __imp_zmq_version. 4) causing undefined reference zmq_version. anyone else faced problem , has solution ?
Read more

.net - Generate assembly with Roslyn -

-
Image
is possible build .net core or better .net standard library roslyn can referenced project? my goal build assembly on server , have people download can reference , use in own visual studio projects. i'm using roslyn generate c# code , compile it. seems work ok when "emit" compilation result memory stream, load assembly , execute code using reflection. using (var ms = new memorystream()) { var compilationresult = compilation.emit(ms); if (compilationresult.success) { ms.position = 0; var assembly = assemblyloadcontext.default.loadfromstream(ms); .. .. is can "save" assembly proving path emit method. results in .dll file on disk. var compilationresult2 = compilation.emit(@"d:\testassembly.dll"); i wonder kind of format .dll file is. doesn't seem "normal" assembly. i searched internet couldn't find doing this. misunderstand something? so questions are: what kind of format file create emit? full...
Read more

batch file - filebot superstrict script: need tiny video sample or other solution -

-
seeing how filebot can make massive mistakes (even in strict mode) when renaming videos created script make sure there's no mistakes , lets me check suspicious ones manually. it uses dummy 0-size copy of video in dedicated folder figure out new name renamed , doesn't tagged video , audio info since it's not real video. it simpler , more accurate have variable tags in place need tiny part of video (with tracks) instead of 0-size dummy. what's easy way this? all unknown variables see extrapolated video filename in other script, should not relevant here ask away if need be. @echo off /f "tokens=*" %%f in ("%full%") ( set "fullpath=%%~dpf" set "file=%%~nxf" ) :: prep fake temp file set tempdir=%temp%\%date:~3,2%%date:~6,2%%date:~11,2%%time:~1,1%%time:~3,2%%time:~6,2% mkdir "%tempdir%" && copy /y nul "%tempdir%\%file%" >nul :: filebot string (to shorten lines) if "%type%"...
Read more