Hello, so I have written several stored procedures that act on individual rows of data by taking in an ID number. I would like to keep several stored procedures that can call this stored procedure at different levels of my database scheme. For instance, when a row is inserted I call this stored procedure. When something else is modified ...
I got a problem with a system running on ASP.NET 1.1. It's a topic right now, but actually it's a recurring issue: Sometimes, the system will become extremely slow, and I wonder if there's a tool to find out what's going on. I know that sounds vague, but that's exactly what my problem is about. The thing is, I can time of course my scr...
Say I wanted to print the response time on my pages like Google do. How would I go about doing this? ...
My project requires that I update the contents of a specific column in an HTML table via an AJAX call to a PHP script. In terms of workload: The table contains about 4 columns and about 20 rows (more rows could be added with time). What would be more (or most) efficient: Replace ONLY the column/specific cells that need to be updated...
hi i tried a select query that contains an left outer join on SQL Server CE and its taking like 30 seconds to execute. and then i changed the same query to be an inner join and its taking less then 1 second. the same outer query is very fast on SQL server 2008. does anyone knows why is that? also what is the fix for this performance pro...
If I replace all object references in my Delphi program with interface references, and use objects which are inherited from TInterfacedObject, will the resulting application run with the same speed as before? Or does the reference counting add a significant execution overhead at run time? ...
Hello, I read here (Douglas Crockford) using prototype operator to add methods to Javascript classes saves also memory. Then I read in this John Resig's article "Instantiating a function with a bunch of prototype properties is very, very, fast", but is he talking about using prototype in the standard way, or is he talking about his spe...
Hello, I use Stacic Page Cache (with cache action helper) to cache most of the pages of my App. This is extremly fast, but not always suitable. How do you cache pages with dynamic data? Eg. layout contains info specific to user. One solution I considered is to load additional data via Ajax. But in my case it would be better to cache...
I am developing a large web app and want it to alter itself dependent on a factor that relates to the stress the database is currently under. I am not sure what would me most accurate/effective/easiest. I am considering maybe the number of current connections or server response time or CPU useage? What would be best suited and possible...
Can anyone tell me if either of these will perform better than the other compiled under Java 1.6? Assume MyObject is a class with one field called listField that has a getter and setter Sample #1: MyObject obj = new MyObject(); List<String> lst = new ArrayList<String>(1); lst.add("Foo"); obj.setListField(lst); Sample #2: MyObject o...
I'm reading a flie with essentially upwards of ~500,000 lines separated out by | for the columns which I am parsing and trying to insert into the database through the CLI.. Is there a better way to read it in so I can use it? Currently I'm inserting it as : $fd = fopen ($txtFileName, "r"); while (!feof ($fd)) { $buffer = f...
By default, NHibernate compiles the mappings when creating the SessionFactory... Is it possible to configure NHibernate so that it compiles the needed mappings "on the go"? So that it only compiles a mapping when it needs it? The reason I'm asking is to work around the lenghty operation on start-up (of a winforms, well, AutoCAD applica...
Assuming indexes are put in place, and absolute-count-accuracy is not necessary (it's okay to be off by one or two), is it okay to use: Option A select count(*) from Table where Property = @Property vs Option B update PropertyCounters SET PropertyCount = PropertyCount + 1 where Property = @Property then doing: select ...
Hi, I started using GraphViz yesterday in order to visualize the relationships between some things—a project I’ve been wanting to tackle for quite a while now. So far, I’ve gotten it pretty well done, but there’s a few things I’m struggling with, specifically getting the chart to look good and how long it takes to process the DOT file—...
Hi, I have a flash application which consist of Grid Components, Button, Label, and Combo-box Components. All these components are used more than 70 times(simultaneously) with in the application. So Its takes too much of memory. So How can I test the memory usage of each component at the time of running. Is there any plug-in available f...
I am Generating a New Sheets using macros. For a New Sheet generation , Data is retrieved from more than 4 MS Access DB. Each DB had minimum 200 field. My Macro code includes 1. Cell locking 2. Alignment and formatting 3. One third of the cells in the sheet had a formulas 4. Cell reference with other Workbooks My problem is e...
select name, (select count(*) from products where products.category_Id=categories.Id) as productCount from categories session.CreateCriteria<Category>() but whats next? i don't even know how to search it in Google? ...
What sort of tools are available to monitor memory usage in methods running from delayed_job? I have looked at memorylogic, oink, bleakhouse but they all either seem designed to work with controllers or I am missing something. Any examples of how delayed_job memory leaks (not with the gem itself but the code it is running) are detected ...
I am having problem with performance of SQLite database in Android application in Samsung Galaxy GT-I9000 device. The database contains 10 tables with 3 - 8 columns each. As soon as a database file gains about 400 KB update/instert queries need much more time to execute - 2 seconds! In comparision to other devices (HTC Magic, HTC Desire...
I need to parse a fairly large XML file (varying between about a hundred kilobytes and several hundred kilobytes), which I'm doing using Xml#parse(String, ContentHandler). I'm currently testing this with a 152KB file. During parsing, I also insert the data in an SQLite database using calls similar to the following: getWritableDatabase()...