|
How fast is the SQL Server solution (import, sort, export?)
|
|
|
|
|
Obviously, the SQL-based solution is much slower as it stores the data to disk as opposed to working directly in memory.
Importing the data is very slow (0.9 ms per row) compared to DataTable, sorting is lightning fast.
However, I can accomplish the task with SQL, which can't be said about the DataTable-oriented solution.
Michal
|
|
|
|
|
A few years ago, I wrote an sort routine for sorting BIG number of records, using the "insertation sort" algorythm (I´m a confused about the naming of the alg ..., maybe he was called "insertation sort" only in this one book ...).
The main idea: for fixed length records, and an known lower and upper key (you know after the first read cycle), its possible to sort the file with only 2 read and 1 write cycle - if you need more, I´ll post something.
|
|
|
|
|
Please go ahead and post more.
I have been working with a huge SQL database of Forex price ticks for almost a year now. By now, it consists of about 270 million rows.
Every fresh idea on how to help with the pre-precessing of the data before importing it into the SQL database is warmly welcome! 
Thanks,
Michal
|
|
|
|
|
sorry for the delay, i was in heavy troubles, so i had no time ...
please post a snipplet of the datafile, i´ll implemnt this insertation sort, and post.
|
|
|
|
|
Hi, Thomas,
I've resolved the issue in the meantime.
Thanks for help,
Michal
|
|
|
|
|
sorry again,
how did you manage it? how is the performance?
greetings, thomas
|
|
|
|
|
hi,
i need to run a winform that gets custom wpf controls from a database or folder and dynamically create another form that display them. whats the approach is should take ?
|
|
|
|
|
HI...please anyone tell me how to convert a word document into a xml document.
|
|
|
|
|
Click the "Save As" menu item and in the dialog set the "Save as type" selection to Xml Document
|
|
|
|
|
:-> you took my great answer  that's a 5 heh!
|
|
|
|
|
look up the Microsoft Word 2007 object model and see what options are available for saving a document as xml.
The link below discusses how to convert a word document to either PDF or XPS using the word object model. However, if you save it as XPS, you can then retrieve all the XML content. Regardless the article below should give a good insight into using the word object model.
http://msdn2.microsoft.com/en-us/library/bb412305.aspx[^]
|
|
|
|
|
how i fill treeview with checked boxes from database?
from two tables have relations
the frist table will be parent nodes
and secind table will be child nodes
and how i will treat with checked??????
plz answer on me with code or send code to me
on
huss_Aldin@yahoo.com
|
|
|
|
|
I can help you by making parent node and child node in one table
and the code will be
public void LoadItems2Tree (TreeNode parentnode , int ParentID)<br />
{<br />
DataCommand = new SqlCommand();<br />
DataCommand.CommandText = "SELECT * FROM Items WHERE ParentID = @ParentID ORDER BY ItemID " ;<br />
DataCommand.Connection = Connection.SqlCon;<br />
<br />
DataParam = DataCommand.Parameters.Add ("@ParentID",SqlDbType.Int);<br />
DataParam.Value = ParentID; <br />
<br />
foreach (DataRow Dr in QueryResult(DataCommand).Tables[0].Rows)<br />
{<br />
TreeNode MyNode = new TreeNode(Dr["ItemName"].ToString());<br />
MyNode.Tag = (int)Dr["ItemID"];<br />
parentnode.Nodes.Add (MyNode);<br />
LoadItems2Tree (MyNode , (int)Dr["ItemID"] );<br />
}<br />
}<br />
<br />
<br />
public DataSet QueryResult (SqlCommand SqlQuery)<br />
{<br />
DataSet DaSet = new DataSet();<br />
DataAdapter = new SqlDataAdapter(SqlQuery);<br />
DaSet = new DataSet();<br />
DataAdapter.Fill(DaSet , "DataTable");<br />
return DaSet;<br />
}<br />
<br />
remmber one table only , and for the check boxes , may be you can find it in treeview properties
Kind Regards
I know nothing , I know nothing
|
|
|
|
|
Hi,
I have an application where I print bills to POS printer connected to serial port COM1. How can I check if printer in turned on and printer status is ok.
When I do serialPort.Write(myString) I do not get any error.
How can I check printer or serial port status?
Thank, Jure
|
|
|
|
|
Most POS printers have a driver/api so that you can do these things more easily.
THe most common printers (in the UK anyway) are the epson TM80's which can use the epson unified stuff:
http://www.pos.epson-europe.com/support/drivers.htm[^]
If yours is a different manufacturer I'd suggesting checking with them.
|
|
|
|
|
Hi,
I am not using any drivers for my printer because I don't use graphical printing. I send text directly to serial port.
<br />
SerialPort serialPort=new SerialPort("COM1",9600,Parity.None,8,StopBits.One);<br />
serialPort.Open();<br />
serialPort.Encoding = Encoding.GetEncoding(852);<br />
serialPort.Write(stringToPrint);<br />
serialPort.Close();<br />
So I must urgently install driver if I completely understand you.
|
|
|
|
|
In addition to what originSH said, a lot of serial type devices also support a control set, where by you send off some command sequence to the device and expect a response. If you don't get a response (or it times out or whatever), then you know something's up.
"It was the day before today.... I remember it like it was yesterday."
-Moleman
|
|
|
|
|
Can you tell me what can I do in my code?
<br />
SerialPort serialPort=new SerialPort("COM1",9600,Parity.None,8,StopBits.One);<br />
serialPort.Open();<br />
serialPort.Encoding = Encoding.GetEncoding(852);<br />
serialPort.Write(stringToPrint);<br />
serialPort.Close();<br />
Thank,
Jure
|
|
|
|
|
how could i change tab page tab hand fold size?
in tabcontrol i have two tab page, so i want to resize their hand hold size which sum of their width must equals to tab control width .
|
|
|
|
|
I think you have to use the Padding property of the TabControl.
|
|
|
|
|
Hi,
in my button_click code I have let's say 4 loops, how can I make them run at the same time and one after another?
|
|
|
|
|
I think I understand what you mean.
To do them at the same time, you will want to nest one loop inside another
<br />
for(int i = 0; i < 10; i++)<br />
{<br />
for(int x = 0; x < 10; x++)<br />
{<br />
Console.Writeline(string.Format("x is = {0}", x.ToString());<br />
}<br />
<br />
Console.Writeline(string.Format("i is = {0}, i.ToString());<br />
}<br />
What will happen is, loop i will initialize, and after executing, it will get to loop x. When it gets to loop x, it will execute, and this output will be produced at the console.
x is = 0
x is = 1
x is = 2 etc etc etc
Once Loop x has finished, loop I will continue, and Loop x will be executed every step through loop i, until it is finished. You could put another loop inside i, or x.
TO run one loop right after another, just do it like you would a regular loop, just with another right after, like so:
<br />
for(int i = 0; i < 10; i++)<br />
{<br />
Console.Writeline(string.Format("i is = {0}, i.ToString());<br />
}<br />
<br />
for(int x = 0; x < 10; x++)<br />
{<br />
Console.Writeline(string.Format("x is = {0}", x.ToString());<br />
}<br />
<br />
Hope that answeres your question
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
|
|
|
|
|
suck123 wrote: run at the same time
read about threading
life is study!!!
|
|
|
|
|
threading won't make them run at the same time either (due to time slicing) unless you have SMP and at least 5 CPUs...
it will run the main app spawn the 4 threads for a total of 5 (one is required for the main app) then execute them one at a time like so:
run one thread then save and unload, load the next and run a little bit then save and unload repeat till all of the threads exit... (yes even if the main app exits first!)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
