性能:将soundex放入DB或在查询后翻译?(Performance: Put soundex in DB or translate it after the query?)
我是MySQL的新手。 我有一个论坛,我正在为此编写搜索功能。 该查询获取论坛的所有条目。 我想结合搜索算法[similar_text()&soundex()]。
我现在的问题是由于表现。 现在,当我在数据库中写入一个新条目时,我要将soundex代码保存在数据库中是否更好? 或者是否因为在soundex()中翻译每个条目的性能更好?
我正在使用symfony2框架。
I am relative new in MySQL. I do have a forum and I am writing a search function for this. The query is getting all entries of the forum. I want to combine a search algorithm [similar_text() & soundex()].
My question now due to performance. Is it better now that I am going to save the soundex code in the database when I am writing a new entry to the datasae? Or is it better due to performance to translate each entry in soundex()?
I am using symfony2 framework.
原文:
最满意答案
问题是由
IIViewDeckController
捕获的滑动事件以打开侧边栏。通过将
IIViewDeckController
panningMode
设置为IIViewDeckController
,它将删除此功能,从而解决UITableView
的问题。The problem was that the swipe event where caught by the
IIViewDeckController
in order to open the sidebar.By setting the
IIViewDeckController
panningMode
toIIViewDeckNavigationBarPanning
it removes this feature and therefore fix the issue with theUITableView
.
相关问答
更多-
对于左向滑块(即显示左侧视图的滑块): - (BOOL)viewDeckControllerWillOpenLeftView:(IIViewDeckController*)viewDeckController animated:(BOOL)animated { self.tableView.frame = (CGRect) { self.tableView.frame.origin.x, self.tableView.fr ...
-
即使调用setResult,也不会调用onActivityResult(onActivityResult is not called even though setResult is called)[2024-03-08]
我解决了这个问题。 我的请求代码是否定的,根据请求代码小于0的记录,结果不会发送。 I figured out the problem. My request code was negative and according to documentary if request code is less than 0, result is not sent. -
我不完全理解发生了什么,但在找到类似的讨论后,我重新实现了它没有flatMap,它的工作原理: .retryWhen(errors -> errors.zipWith(otherObservable, dummyZipFunction)); I don't understand fully what's happening but after finding this similar discussion i reimplemented it without flatMap and it works: . ...
-
我忘了我在方法canEditRowAtIndexPath返回NO I forgot that I was returning NO in the method canEditRowAtIndexPath
-
试试这样: private String best; // OnCreate中 Criteria criteria = new Criteria(); best = locationManager.getBestProvider(criteria, true); locationManager.requestLocationUpdates(best, 300000, 0, this); I found a problem. GPS in my phone isn't working. If I use ...
-
解决方案是删除AppDelegate和TabBar之间的任何“deck构造函数”类。 当您需要设置或更改Deck结构时,我为每个结构创建了几个方法。 例如,如果你想让Deck在左侧有“leftView”视图控制器,在右边有“rightView”,在中心有“tabBarHome”,在App Delegate中创建一个这样的方法: -(void) lanzarHome{ UIStoryboard *storyboard = [UIStoryboard storyboardWithName:@"Main" bun ...
-
我也遇到过这个问题。 我的决定是:将观察者添加到通知UIApplicationWillChangeStatusBarFrameNotification并将任何方法设置为它的选择器。 然后,在这个方法中,我创建了新的UINavigationController与旧的视图控制器(位于中心)作为rootViewController 。 然后我用这个UINavigationController设置IIViewDeckController类实例的属性IIViewDeckController 。 希望能帮助任何人。 I ...
-
这是我做的,卸载Xcode 5和6只重新安装的Xcode 6,Ran项目和它工作。 经过2天的调试后,重新安装就可以了。 Here is what I did, uninstalled Xcode 5 & 6 both the reinstalled Xcode 6 only, Ran the project and it WORKED. After 2 days of debugging its the reinstall which did the trick.
-
使用禁用菜单的打开功能 _deckController.panningMode = IIViewDeckNoPanning; 并重新启用它 _deckController.panningMode = IIViewDeckDelegatePanning; 这有助于: UIViewController忽略左/右滑动 Disable the menu's opening ability with _deckController.panningMode = IIViewDeckNoPanning; and re-e ...
-
问题是由IIViewDeckController捕获的滑动事件以打开侧边栏。 通过将IIViewDeckController panningMode设置为IIViewDeckController ,它将删除此功能,从而解决UITableView的问题。 The problem was that the swipe event where caught by the IIViewDeckController in order to open the sidebar. By setting the IIView ...