I have a SQL table it has more than 1000000 rows, and I need to select with the query as you can see below:
SELECT DISTINCT TOP (200) COUNT(1) AS COUNT, KEYWORD
FROM QUERIES WITH(NOLOCK)
WHERE KEYWORD LIKE '%Something%'
GROUP BY KEYWORD ORDER BY 'COUNT' DESC
Could you please tell me how can I optimize it to speed up the execution…
Hi,
I have following code as UIImage+Scale.h category.
-(UIImage*)scaleToSize:(CGSize)size
{
UIGraphicsBeginImageContext(size);
[self drawInRect:CGRectMake(0, 0,…
In my program, I've got a menu with a group of RadioMenuItem entries. Choosing one of them should trigger a function which can either succeed or fail. If it fails, this RadioMenuItem shouldn't be marked chosen (the previous one should persist). Besides, sometimes I want to set marked item without running the choice processing function.
Here is my…
Hi,
I need to work with many images, and I can't hold them as UIImage in memory because they are too big.
I also need to change colors of image and merge them on the fly.
Creating UIImage from underlying NSData, change color, and combine them when you can't have many images on memory is fairly slow. (as far as I can get)
I thought maybe I can…
Hi! I've decided to learn Symfony and right now I am reading through the very start of the "Practical Symfony" book. After reading the "Web Server Configuration" part I have a question.
The manual is describing how to correctly configure the server: browser should have access only to web/ and sf/.../ directories. The manual has great…
In a simple webapp I need to map URLs to filenames or filepaths.
This app has a requirement that it can depend only on modules in the core Perl ditribution (5.6.0 and later).
The problem is that filename length on most filesystems is limited to 255. Another limit is about 32k subdirectories in a single folder.
My solution:
my…
Properties seem to be a powerful feature of Subversion. The manual provides some interesting examples of using them. But how do YOU use this feature in your projects?
I am a newbie who is trying to create a Facebook app using PHP and Facebook's PHP SDK. The app is hosted on Heroku, and the sample app that they provided is working fine. However, I am now trying to get the sample app to work on Apache 2.2, and I have encountered a lot of problems along the way. Well, straight to the point, my…
Is it possible to get information about post field order in ASP.NET? I need to know whether some field was the last one or not.
I know I can do it through Request.InputStream, but I’m looking for a more high level solution without manually stream parsing.
Generally I’m doing testing of http post sent by my application and…
I'm creating a simple training project. I've implemented a controller method, which deletes an item from the list. The method is looking like this:
@Controller
@RequestMapping(value = "/topic")
public class TopicController {
@Autowired
private TopicService service;
...
@RequestMapping(value =…
The database is then transferring the data to a spinner which I want to leave position 0 blank so I can add a item to the spinner with no value making it look like a prompt. I have been going at it all day. FAil after Fail
MainActivity
public class MainActivity extends Activity {
Button AddBtn;
EditText et;…
i have a c++ class with CGrect variable and i'm getting segfault when trying to access it.
class Parent
{
//with some virtual functions/dtors
};
class Child
{
public:
void SetRect(CGRect rect) { mRect = rect; }
CGRect GetRect() { return mRect; }
int GetIndex() { return mIndex; }
private:
…
Hi,
I've seen iphone related open source library which says something like,
"You need 4.0+ iOS build environment but the code will run on 3.0+ iOS device."
I wonder how those two requirements can differ and how can I tell a minimum 'device' iOS version which a certain api would need.
For instance I want to…
I looked for a way to scan database for a specific table. For example i have:
Database: system_ultimate Table: system_settings
And let us say, that one doesn't know precise name of the table. He only knows, that it is some how connected to word settings. How could he search for that table name then?
I…
Hi.
Among many animation scenarios, there are times when I want an object to move a straight line then change direction, move another straight line and so forth.
Assuming I would use either UIImageView or CABasicAnimation with image arrays.
Does it make difference to provide more images when the object…
Looking for a way to rename files that are uploaded by users through a filefield. For example, rename user profile photos using uniqid.
I found a good solution for D6 here:
http://www.wesjones.net/home/2011/03/drupal-6-how-to-change-filename-on-upload
but can't find anything for D7.
Another option is…
Task at hand: Microsoft sign drivers on Win 7.
I microsoft signed my driver package 3 times every time thinking I might have missed a step or something. However, I cannot seem to get rid of the Windows Security error message "Windows can't verify the publisher of this driver software'. This is not…
Task at hand: Microsoft sign drivers on Win 7.
I microsoft signed my driver package 3 times every time thinking I might have missed a step or something. However, I cannot seem to get rid of the Windows Security error message "Windows can't verify the publisher of this driver software'. This is not…
Oracle is hosting an Eclipse DemoCamp next week, Wednesday, June 13, in Redwood Shores, CA (@Oracle
HQ) from 6pm - 9pm. Come view presentations from folks who are developing exciting
technologies for the Eclipse platform and network with your colleagues
and peers over beer and…
Hello,
Is there a way to make ChangePassword control work without Membership provider? Like the same way Login control works through an Authenticate event, could I make this component to use my password changing function and then showing success view without me writing custom provider?
…
My team and I are meeting tonight to come up with a business plan and some community input would be amazing.
I've been mulling over this issue for the past few months and bouncing ideas off of others, and now I'd finally like some input from the community.
I have come up with a fair…