Which search engine would you recommend for a Commerce website? We have millions of products in a catalog and we want it to be as quick as possible. We would also want to make sure that the marketing driven through the search engine will be fast and effective. What are your opinions? ...
What is an example of a fast SQL to get duplicates in datasets with hundreds of thousands of records. I typically use something like: select afield1, afield2 from afile a where 1 < (select count(afield1) from afile b where a.afield1 = b.afield1); But this is quite slow. ...
Hey, I got to create script that would compare thousands of large texts (to each other). And I'm wondering if MySQL is the best solution for this. Is there any other free databse system I could use to do simple - but processor-time consuming computing? Please, throw me into your knowledge's pool! Edit: Nature of documents - 500-7000 c...
I want a small (< 30MB) standalone Windows executable (a single file) that creates a window which asks the user for the location of a directory and then launches a different program in that directory. This executable has to run on XP, Vista, Server 2003, and Server 2008 versions of Windows in 32-bits and 64 bits on x86-64 architecture...
I have the following data: ExamEntry Student_ID Grade 11 1 80 12 2 70 13 3 20 14 3 68 15 4 75 I want to find all the students that passed an exam. In this case, if there are few exams that one student attended ...
I'm looking for some examples of production websites that currently use the Telerik Rad Grid. I'd really like to see some real world scenarios in action, other than the Telerik RadGrid demo. Does anyone know of any websites that use it? ...
Is there any linux command line implementation that performs exceptionally well for generating sha1's on large files (< 2GB)? I have played around with 'openssl sha1' and it takes minutes to get the sha1 for a 2GB file : /. ...
I'm trying to write a method that will calculate if two circles are overlapping. I've come up with the following and I'm just curious to know if there is anyway it could be optimised further. private static boolean isCollision(Point2D p1, float r1, Point2D p2, float r2) { float a,dx, dy; a = (r1+r2) * (r1+r2); dx = (float) (p1.getX()...
I have 3 Bitmap point . Bitmap* totalCanvas = new Bitmap(400, 300, PixelFormat32bppARGB); // final canvas Bitmap* bottomLayer = new Bitmap(400, 300,PixelFormat32bppARGB); // background Bitmap* topLayer = new Bitmap(XXX); // always changed. I will draw complex background on bottomLayer. I don't want to redraw complex background on to...
Can someone recommend me good but small HTML editor. Right now I'm using EditPlus and it's really great and almost what I need, but it lacks few stuff that would come very handy. I'd like EditPlus (or whatever other piece of software) to show me where the tag I clicked ends. For example, if I have few large tables on the page, and when ...
I am currently writing a fast 32.32 fixed-point math library. I succeeded at making adding, subtraction and multiplication work correctly, but I am quite stuck at division. A little reminder for those who can't remember: a 32.32 fixed-point number is a number having 32 bits of integer part and 32 bits of fractional part. The best algor...
I'm wondering if anyone knows of a fast (i.e. O(N log(N)) ) method of calculating the average square difference function (ASDF) or average magnitude difference function (AMDF) for a periodic signal, or it is even possible. I know that one can use the FFT to calculate the periodic cross correlation. For example, in Matlab code, for i=1:...
Daily I have 5 million or so unique keywords with an impression count for each one. I want to be able to look these keywords up by certain words so for instance if I have "ipod nano 4GB" I want to be able to pull that out if I search for "ipod", "nano", or "4GB". mySQL can't seem to handle that much data for what I want, I've tried Ber...
Is there any light version of richtextbox control? I've got to create like 300+ of them in an app which takes time, memory and slows everything down... All that I need is to have a control that will enable me changing the background/foreground of a part of the text... I'd need that in winforms... anybody know anything about some kind of ...
Initial tests indicate that GDI+ (writing in VB.NET) is not fast enough for my purposes. My application needs to be able to draw tens of thousands of particles (coloured circles, very preferably anti-aliased) in a full screen resolution at 20+ frames per second. I'm hesitant to step away from GDI+ since I also require many of the other ...
What is the fastest way (Algorithm) to generate 500,000 static html files from DB? And is it a good practice to put all this files in single folder? or create hierarchically for this files? We want to handle about 6,000,000 concurrent hit, so the static files will be a good solution for that. the source DB will be simple flat table wi...
I've just released a PHP framework called EuropaPHP (http://europaphp.org/). I was wondering if I could get some feedback from of you guys whatever it may be. Let me know what you like about it, what you don't like about it; whatever. It's based on similar coding conventions to that of the Zend Framework and as a result, the Zend Framew...
Hi guys, PROBLEM: I need to write an advanced search functionality for a website. All the data is stored in MySQL and I'm using Zend Framework on top. I know that I can write a script that takes the search page and builds an SQL query out of it, but this becomes extremely slow if there's a lot of hits. Then I would have to get down to t...
Is it better to have if / else if, if every block in the if statement returns, or is it better to have a chain of ifs? To be specific, which if fastest: A: if (condition1) { code1; return a; } if (condition2) { code2; return b; } //etc... B: if (condition1) { code1; return a; } else if (condition2) { code2; return b;...
I am programming in windows c++. I want to know which is the fasted method to draw a DIB onto Screen. The image maybe stretched. Faster than StretchDIBits, Faster than SetDIBitsToDevice. Faster than StretchBits. and with high stretch quality. Many thanks! ...