|
I've found it usually isn't the INSERT that is slow it is the database roundtrips that are slow. If the framework supports it then you should batch a number of INSERTs into one Command and send them together.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
But how can i do this?
--------------------------------
visit: http://pmartike.deviantart.com/
|
|
|
|
|
SQL Server CE is in-process so the round-trip problem doesn't apply. The parser only accepts one statement per batch. The parser is appallingly slow and the query execution engine isn't much better. You actually get best performance by simply opening the tables directly (specify the table name for SqlCeCommand.CommandText and set SqlCeCommand.CommandType to CommandType.TableDirect) and not using SQL at all (ironically).
In CF 1.0 you could read tables directly but not update them - you had to use INSERT queries and Prepare the command object to avoid the query compiler overhead. CF 2.0 has a SqlCeResultSet class which is back to the bad good old days of ADO Recordset - you can scroll back and forth with a client-side cursor, seek to specific values, update or delete existing rows and insert new rows.
|
|
|
|
|
Mike Dimmick wrote: SQL Server CE is in-process so the round-trip problem doesn't apply. The parser only accepts one statement per batch.
Ah, okay - I've never used it.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
Ready to Give up - Your help will be much appreciated.
My website
|
|
|
|
|
For SQL Server 2005 Mobile Edition/SQL Server CE 3.1, with .NET Compact Framework 2.0, you can manipulate the tables directly (as it's an in-process database engine).
Open a SqlCeResultSet directly on the table you want to insert into. Use the CreateRecord method to get a SqlCeUpdatableRecord, which you set the properties of. Then use the resultset's Insert method to update the table. Reportedly, this is much faster than using any SQL INSERT query, even if you Prepare the command object.
In fact SQL Server CE is reportedly much faster if you manipulate tables directly and use the navigation methods on SqlCeResultSet or SqlCeDataReader than using any form of SQL. Only use a SELECT query when you want to do a complicated join.
You can open an updatable resultset directly on a table by doing:
using( SqlCeCommand cmd = new SqlCeCommand( "MyTable", conn ) )
{
cmd.CommandType = CommandType.TableDirect;
using( SqlCeResultSet rs =
cmd.ExecuteResultSet( ResultSetOptions.Updatable ) )
{
}
}Note that this is unique to SQL Server CE - you cannot open tables directly with the full SQL Server 2000 or 2005.
|
|
|
|
|
Thank you 
I'll try it..
--------------------------------
visit: http://pmartike.deviantart.com/
|
|
|
|
|
|
Suppose the next code:
<StackPanel Orientation="Horizontal" Width="120" Height="30">
<Ellipse Fill="#FFBF5757" Stroke="#FF000000" />
</StackPanel>
How do I to make the ellipse the same width of the stackpanel?
<StackPanel Orientation="Horizontal" Width="120" Height="30" <b>x:Name="panel"></b>
<Ellipse Fill="#FFBF5757" Stroke="#FF000000" <b>Width={panel.Width}</b> />
</StackPanel>
I don't know how. Thanks for any help
Juan Pablo G.C.
Overrider Blog
|
|
|
|
|
If Ellipse is always supposed to be the same width as the StackPanel, get a handle on the Elipse node and use node.Parent to get at StackPanel.
Hogan
|
|
|
|
|
hi all
i just want to know
if i want a similar kind of calendar tool as asp.net has (in java script)
what should i do for that calendar ... few validations have to be done...
i saw in net what i found was tools are available saying calendar.js..
is tat only way or so ..
i found even ajax tool kit also...
but i am struggling ot add up to my project
if someone has got articles please do help me ...
|
|
|
|
|
for ajax controls see this
http://www.asp.net/
|
|
|
|
|
Hi Guys,
i am using codeSmith to develope website and have a problem:
I know that all the stored are generated automatic when using netTiers to generate. but i have a function search user stored like this:
Alter Procedure SearchUser
@searchKey varchar(500)
As
select u.*
from users u
where u.userID in
(
select fmem.userID
from dbo.FamilyMembers fmem
where fmem.famID in
(
select f.famID
from dbo.Families f
where f.famName like '%'+@searchKey+'%'
)
)
GO
Please help me how to assgin UserService execute this store without re-generate source code
Thuan
|
|
|
|
|
Weren't there any vendor KBs on this issue?
|
|
|
|
|
Hello EveryBody,
I am new in windows application,
I am not able to set the number of rows in listview.
I want to display only ten records at time.
Regards,
rahul saini
|
|
|
|
|
You need to do list yourself... There's no paging-like functionality in a listview....
|
|
|
|
|
Hi!
The number of rows in a ListView depends on the value of its VirtualMode property.
If you don't run the ListView in virtual mode (the default) then the number of rows is equal to the number of ListViewItems inside the Items collection.
If you're running in virtual mode, there's a special property VirtualListSize to hold the number of items in the ListView. Using the ListView in virtual mode is an advanced topic, though.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
Hi,
my application has an update feature: after the user clicks an update-button, my program checks wheather there is a newer version on the server. If yes, it is downloaded with a temporary filename into the program-folder. Then a separate update-exe is started, which replaces the old program.exe with the newer one by deleting the old and renaming the new file.
The problem is, that in Vista (but also in older systems) the write access to the program-folder is restricted.
Do you have an idea how I could work around this restriction or what I could do to keep this fast update feature available to my customers? E.g. my ZoneAlarm also has such an update-feature although I don´t know how this works...
Thanks in advance
Alex
|
|
|
|
|
|
Thanks for that hint! This seems to be very interesting...
|
|
|
|
|
OK, now I´ve read the article http://msdn.microsoft.com/msdnmag/issues/03/02/bits/ about that, but as far as I understand, the problem I mentioned is not explicitely addressed there. One thing is the download-process done by the BITS API, but another thing is how to replace the application-files, but in that article it is presumed that files can be renamed/deleted inside the program folder.
Do you agree with that? Then I have the same problem as before, that under Vista I will not be able to manipulate the files in the program directory. Or can I?
|
|
|
|
|
Hi!
If you try to modify files in the program directory, all changes will be virtualized to a directory in the user profile.
This does not happen if your program is running with elevated rights. You can achieve this by embedding a manifest into the application telling Vista that your updater application requires elevated rights to perform correctly.
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
Thank you! But what is a manifest? How does it look like? I could not find anything specific about that thing...
|
|
|
|
|
How to embed a manifest can be found here[^], the contents of the manifest file can be easily found here using google[^].
Regards,
mav
--
Black holes are the places where God divided by 0...
|
|
|
|
|
I want to ger CPU,Memory & Disk utilization of Windows machine using C# application.
If you have any idea about that pls reply me via email.
email : kaushal654@yahoo.com
|
|
|
|
|
Hi
Read up on System.Diagnostics.PerformanceCounter .
For a general question like this it is best to google first [^]. Generally, people post specific problems here.
Just curious - do you find you get a lot of spam?
"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
