Hi guys, im in the beginning of the complete restyle of an my web application, and i have some doubt about a good database-design that can be reliable, query-performance, and in the same time fully customizable by the users (users wont customize the database structure, but the funcionality of the application). So, my actual situation is...
I understand that the answer to this question may depend on registry settings and on the version of Windows, and perhaps on the amount of RAM if there is not enough memory. For the sake of this question, assume that the server has plenty of RAM (3+ GiB). If an application (3rd party application in this case) leaks handles at a few hund...
I have a mysql (5.0.22) myisam table with roughly 300k records in it and I want to do a lat/lon distance search within a five mile radius. I have an index that covers the lat/lon fields and is fast (milisecond response) when I just select for lat/lon. But when I select for additional fields in the table is slows down horribly to 5-8 ...
I have written a chart that displays financial data. Performance was good while I was drawing less than 10.000 points displayed as a connected line using PathGeometry together with PathFigure and LineSegments. But now I need to display up to 100.000 points at the same time (without scrolling) and it's already very slow with 50.000 points...
Which method do you suggest to efficiently secure your embedded database in Delphi applications? Here are the methods I've tested: Using Molebox Pro Pros - Fast, unpacking is not child's play, no additional task/coding Cons - Database will be read-only, same drawbacks as exe compressors Using DISQLite3 Pros - Overcome Molebox's r...
Hi All, I am developing an application for the Android platform which contains 1000+ image filters that have been 'evolved'. When a user selects a photo I want to present the most relevant filters first. This 'relevance' should be dependent on previous use cases. I have already developed tools that register when a filtered image is ...
I saw some existing code in the PHP scripts doing a system('hostname'); how big can the performance impact on the server be if using this method? ...
What should be the best way to write code: 1) Dim current = Request.Path current = current.Remove(0, 1) current = current.Replace(".aspx", "") 2) Dim current = Request.Path.Remove(0, 1).Replace(".aspx", "") 3) Dim current = Request.Path Dim current2 = current.Remove(0, 1) Dim current3 = current.Replace(".aspx", "") Or 1-2 mak...
I have setup a wordpress based blog for online flash games. The website is www.nirgame.com. i need to know what tools can be used for performance testing the website. Sorry for being naive but i come from the C++ world and this PHP/Apache/MySql thing is new to me. ...
I'm running an application right now which seems to be running at full throttle, but even though the fan seems to be spinning at it's max and the activity monitor reports that the application is using 100% of the processor, I'm suspecting that at the most it is using 100% only of a single of the two cores on my machine. How can I tell O...
I am just getting started with Linq, WPF and Silverlight. I am trying to display data which originates from a XML document in a DataGrid. I use a Linq query to select the objects I want and link the result to the DataGrid. XDocument doc = GedView.GedcomConverter.ConvertToXml(new StreamReader(e.Result)); var query = from person in doc.D...
The reports that I use (and update) are taking a long time (some take hours). I felt this is far too long and asked previously about this. After taking a long look at various web sites that discuss SQL performance, they all take the stance of being DBA's. However I'm not, and neither are my colleagues (I guess if we had a DBA then we wou...
I have to split huge file into many smaller files. each of the destination file is defined by offset and length as number of bytes. I'm using the following code: private void copy(string srcFile, string dstFile, int offset, int length) { BinaryReader reader = new BinaryReader(File.OpenRead(srcFile)); reader.BaseStream.Seek(offse...
Our primary database server is an 8 core box with 8GB of RAM. The CPU is a Xeon E7330 @ 2.4GHz. It runs Windows Server 2003 R2 (x64 edition) and SQL Server 2005 I wanted to do some testing so I set up SQL Server 2005 on another brand-new server which is an 8 core box with 4 GB of RAM. It has a Xeon X5460 @ 3.16GHz and runs Windows Serve...
I've heard lots of people saying that the IN keyword in most relational databases is slow. How true is this? An example query would be this, off the top of my head: SELECT * FROM someTable WHERE someColumn IN (value1, value2, value3) I've heard that is much slower than doing this: SELECT * FROM someTable WHERE someColumn = value1 O...
Hi I have created a PerformanceCounterCategory like below var category = PerformanceCounterCategory.Create("MyCat", "Cat Help", PerformanceCounterCategoryType.SingleInstance, "MyCounter", "Counter Help); Now i would like to add a new counter to the category to monitor another item but i can't find the api call to do it. Any Ideas? ...
I have some template string this is my {0} template {1} string which I plan to put user values in using String.Format(). The string actually is longer so for readability I use: this is my {goodName1} template {goodName2} string And then String.Replace each parameter with its value. How can I get the highest performance and ...
I haven't found many ways to increase the performance of a Java application that does intensive XML processing other than to leverage hardware such as Tarari or Datapower. Does anyone know of any open source ways to accelerate XML parsing? ...
Mason asked about the advantages of a 64-bit processor. Well, an obvious disadvantage is that you have to move more bits around. And given that memory accesses are a serious issue these days[1], moving around twice as much memory for a fair number of operations can't be a good thing. But how bad is the effect of this, really? And what ...
Below is my C wrapper for a Fortran ZHEEVR routine from well-known LAPACK numerical library: void zheevr(char jobz, char range, char uplo, int n, doublecomplex* a, int lda, double vl, double vu, int il, int iu, double abstol, double* w, doublecomplex* z, int ldz, int* info) { int m; int lwork = -1; int liwork = -1; int l...