I just got a code handed over to me. The code is written in C# and it inserts realtime data into database every second. The data is accumulated in time which makes the numbers big. The data is updated within the second many times then at the end of the second result is taken and inserted. We used to address the dataset rows directly w...
I have millions of records that need can be searched and then appear in a ListView. Currently, these items are stored in an SQLite internal database. Does anyone have a recommendation on the best method to feed these items into a ListView and have people scroll through them? Speed is critical here. I don't want to do a "SELECT *" off o...
My company is at the very end of development process of some (awesome:)) web application. This app will be available as a online service for (hopefully) some significant number of users. This is our biggest django release so far and as we are preparing to release some question about deployment have to be answered. Q1: how to determine r...
Hi, I am trying to use regular expressions to determine what format the user have applied when entering input in a textbox. The regular expressions are as follows: (\\s?[" + alphabet + "]{9,9})+ To determine whether the input is one or more strings of length 9 in a given alphabet, possibly separated by whitespace. (>[\\w\\s]+\\n[" +...
After doing my exercise in school, I use Sqlite to store my data. But there's XML / JSON [ I haven't tried yet, but I prefer JSON because its' simplicity ], they're used to store data too. And they seems popular, there's JSON for C#,C++,py .... I wonder when to use these ones ? And I'm happy to hear about theirs performance too, I care...
in my C# application i need to store huge amounts of constant strings in arrays, like one array for first names and one for last name and so on... These strings never change so my question is how to store them ? Make a static constant class with these arrays ? Load them at runtime from somewhere? Or any other solution... PS: I don't...
On SO, there are quite a few questions about performance profiling, but I don't seem to find the whole picture. There are quite a few issues involved and most Q & A ignore all but a few at a time, or don't justify their proposals. What Im wondering about. If I have two functions that do the same thing, and Im curious about the differenc...
I'm wondering if it's better to make one or several files for CSS files ? I always see websites with a plenty of css files, but it seems better to use only one large file. What's your advice ? ...
From the performance view, is it better to check or not to check for Nothing(null) before set it? Is clear that for readability maybe there is no need of supplementary step, but for performance? Maybe testing the IF is less time consuming that setting to NULL, if there is no need of?! I run that on a computer, and the result was the sa...
what is the fastest way to get performance metrics of all spring services? ...
(Commonly called the C10K problem) Is there a more contemporary review of solutions to the c10k problem (Last updated: 2 Sept 2006), specifically focused on Linux (epoll, signalfd, eventfd, timerfd..) and libraries like libev or libevent? Something that discusses all the solved and still unsolved issues on a modern Linux server? ...
In PHP 5 and later what's faster - an interface or abstract class ? abstract class MyPluginModel { vs interface MyPluginModel { Any ideas how they compare in terms of memory and time performance? ...
Consider the following queries. select * from contact where firstname like '%some%' select * from (select * from contact) as t1 where firstname like '%some%' The execution plans for both queries are same and executes at same time. But, I was expecting the second query will have a different plan and execute more slowly as it has...
I am working on a application. It is in its initial stage so the number of records in table is not large, but later on it will have around 1 million records in the same table. I want to know what points I should consider while writing select query which will fetch a huge amount of data from table so it does not slow down performance. ...
Hi, I have a website,which decently performs in FF and other browsers. but when it come to IE 7 and IE 8 (tested) the performance gets too slow http://ratingscorner.com/Mobiles/Blackberry-Bold-9000 any tips to improve performance in IE? ...
I'm working on writing a compiler and one feature of this compiler is that it automatically generates GetHashCode(), Equals(object), and Equals({this value type}) methods for value types. Right now the Equals({this value type}) implementation basically generates il equivalent to the il generated by this c#: public bool Equals(ThisType o...
Hi expert Pythonists out there, I am starting to use cProfile so as to have a more detailed timing information on my program. However, it's quite disturbing to me that there's a significant overhead. Any idea why cProfile reported 7 seconds while time module only reported 2 seconds in the code below? # a simple function def f(a, b): c...
I am using pythons built-in sqlite3 module to access a database. My query executes a join between a table of 150000 entries and a table of 40000 entries, the result contains about 150000 entries again. If I execute the query in the SQLite Manager it takes a few seconds, but if I execute the same query from python, it has not finished aft...
Each time I have downloaded a new copy of Rakudo Perl 6, I have run the following expression just to get an idea of its current performance: say [+] 1 .. 100000; And the speeds have been increasing, but each time, there is a noticeable delay (several seconds) for the calculation. As a comparison, something like this in Perl 5 (or oth...
Hi, So i have a database where there is a lot of data being inserted from a java application. Usualy i insert into table1 get the last id, then again insert into table2 and get the last id from there and finally insert into table3 and get that id as well and work with it within the application. And i insert around 1000-2000 rows of data...