Solution:
Tweaked it by delegating the LIKE statement to another (self-written) function that turns back true or false. This reduced the same query back to about 4 seconds.
DataRow[] nbr_in_path_dr = ed_ds.Tables["ed"].Select("id='" + conversion["even_distribut ion_id"].ToString() + "' AND " + overviewType + "='" + ovt_r[overviewType].ToString() + "' "+
...
Cappamontana
Last Activity: Feb 2 '11, 03:35 PM
Joined: Sep 27 '07
Location:
-
-
c# DataTable.Select LIKE statement performance
Hi,
I have a question for those who have some experience with select LIKE statements on huge data (about 200 million rows).
When I run some computing and filtering on this table, it takes the code about 2 seconds to report back. But when I put a LIKE filter in the DataTable.Selec t() it suddenly takes 38 seconds. This only happens when I use a LIKE statement, any other statement is no problem.
Do you guys have... -
XML double convertion fails
Hi,
I have weird problem. When I export a XML document from a .NET C# WebService, the values that should be doubles are converted to 0. But this is only happening when I invoke the service externally. If invoke it on the server itself the values are fine (like 0.3456).
What could be the problem? I've didn't tried the IFormatProvider argument in Parse.Double.
Tnx in advance. -
Yes, I've tried that already, but it seems not possible to do a post from an AJAX requested page. Since the page that is posting is a html page it needs javascript to automatically post.Leave a comment:
-
Hidden IFrame post to Web API result in browser navigation error
Hi,
I have problem that drives me creazy. I have a tracking script that runs on the websites of our customers.
The problem is the following:
- When a visitor visits a page a javascript triggers a dom created IFRAME that locates to a file on the server of out customer.
- This file (WebServiceClie nt.html) is posting automatically (DOM) to a Webservice running on our cloud, so we can save visitor data.
... -
Installation directory Webservice
Hi,
I was wondering if anybody knows how to gather installation directory data from inside the webservice itself. Reason for this is a file which is been included on an install. I need to locate this file...
Anyone knows how I can do this? -
MySql Order By multiple columns BUGGY?
Hi there,
Now I've read the ORDER BY section of the mysql documentation, but still have no clue, what strategy I have to follow now.
The problem is that I want to query the DB like:
[CODE=mysql]SELECT * FROM tr WHERE report_id='a408 58a6-d286-9d34-1ada-47e116c72699' ORDER BY pr DESC,loc DESC,DMZ DESC,url ASC,os ASC [/CODE]
But after the second ORDER BY statement every other ORDER BY statement is being ignored.... -
Ok, but I want to access the context menu from outside my application. So, lets say that someone using my application right clicks on a selected text in some application (Internet Explorer, or Word), I want to put my menu item in that context menu.
Is that possible?...Leave a comment:
-
I don't know your code but I had the same problem...I fixed it by using BackgroundWorke rs.Leave a comment:
-
c# Catching rightmouseclick (application independent)
Hi everyone,
I want to build a solution that is listening to rightmouseclick s of a selected text (application independent). Once clicked there should appear something similar to "Cut" or "Copy" ("Analyze text"-in my case-) in the menu.
I want to catch the action (menu item clicked) and the selected text and do something with it and than show a messagebox or something.
Does somebody... -
Yes I'm pretty sure. But what I want to achieve is that when the service is done, it stops it self. Also when the application(fro ntend) tells the service to stop, it just stops....Leave a comment:
-
.NET C# Windows Service stop() problem
Hi,
We have a .Net project containing 1 Windows Application and 3 Windows services. The project is quite complex and is still in development. The services can be started and stopped by using the application. Also there are some timers in it which triggers the service on a specific time to start (scheduled). When the service done it stops itself so the resources come free.Though it is running fine since 4-5 months, now and than we get... -
Hi Atli,
Sorry I was out for a while...I'am familiar with the javascript way,I jus't didn't know it was the proper way to do it.
Thanks anyway... :D
p.s You have an idea about the background running task?Leave a comment:
-
Dynamic updating text and background running task
Hi,
I was wondering if somebody knows a simple way to update a (status) text in PHP without refressing. The situation is as follows;
I have a class that scrawls a domain and gathers the keyword denstity of a certain page within that domain. Now I want to show the user what the status is of the task (in %). Maybe I can use ob_flush() or flush() in combination with IFRAMES, but I prefer to don't. The problem with AJAX for as far as I... -
:$ sorry ... It now works perfectly! This surely made me learn a bit about IComparer. Thank you for your help!Leave a comment:
-
LOL! Plater it keeps complaining :(
1.The best overloaded method match for 'System.Array.S ort(System.Arra y)' has some invalid arguments \Projects\test\ Program.cs 22 13 test
2.Argument '1': cannot convert from 'void' to 'System.Array' \Projects\test\ Program.cs 22 24 testLeave a comment:
-
Sorry, won't work...
1.The best overloaded method match for 'System.Array.S ort(System.Arra y, System.Array)' has some invalid arguments \Projects\test\ Program.cs 22 13 test
2.Argument '1': cannot convert from 'System.Collect ions.ArrayList' to 'System.Array' \Projects\test\ Program.cs 22 24 test
3.Argument '2': cannot convert from 'test.sortAscen ding' to 'System.Array' \Projects\test\ Program.cs 22 29 testLeave a comment:
-
Small problem left :D don't know how to fill in the arr.Sort(...) and if it will work like this.
Thank you!
...Code:using System; using System.Collections; using System.Collections.Generic; using System.Text; namespace test { class Program { static void Main(string[] args) { ArrayList arr = new ArrayList();Leave a comment:
-
Yes I saw it, thanks...It was only a sample code and in the actual source it's written right. I changed it now in the post. I could have use DataTables but me was said that this is a much faster solution :S
I will try to typecast and see if it works, thanks!Leave a comment:
-
How can I do that? Simply by "(Hashtable)... " or "as Hashtable"? Can you give an example please? And whats wrong with the structure? How would you do it in a situation where you have to save columns and rows?Leave a comment:
No activity results to display
Leave a comment: