Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
3

3fonov

@3fonov
About
Posts
10
Topics
5
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Updating ItemsControl layout
    3 3fonov

    I'm implemented custom VirtualizingPanel that takes care about object X and Y properties to arrange items. How can i update arrangement when this props (X and Y) changed? I'm trying to get item's corresponding UIElement to arrange update but cannot find solution for this. Thanks in advance.

    WCF and WF question announcement

  • Insert mutiple items in ObservableCollection<t></t>
    3 3fonov

    This is exactly what i'm looking for. Tried to do this before but doesnot take in mind about OnCollectionChanged(new NotifyCollectionChangedEventArgs(NotifyCollectionChangedAction.Reset)); Thanks a lot.

    WCF and WF design question

  • Diaplaying a lot of scattered objects
    3 3fonov

    Is it any other solution to display a lot of objects in 2d plane (ships on map) rather than using templated listbox? When i'm reach about 1000 units there terrible slowness. I thought about custom virtualizing panel but it's not so easy to implement it's updates: as i know it triggers when collection changed rather than object property changed. So if targets run away visible area there's no way to detect this. I need only 50-100 items to be virtualized from within 1000-5000. Any suggestions how it's can be done? Thanks.

    WCF and WF question

  • Insert mutiple items in ObservableCollection<t></t>
    3 3fonov

    Thanks a lot. First one is good enough at system startup when a lot of items received but unusable during runtime. Second soluction return IEnumerable. So i need to use ctor after that. This not i'm actually want. If system running and i'll recreate object collection i'm also need to recreate all bindings to it. It's seems imposssible :-)

    WCF and WF design question

  • Insert mutiple items in ObservableCollection<t></t>
    3 3fonov

    Is it possible to insert multiple items in ObservableCollection? I have about 5000 items and inserting it one by one causing UI to go very slow. Thanks.

    WCF and WF design question

  • SQL Server Speed
    3 3fonov

    What can cause slowness of SQL Server 2005 Enterprise? When start same DB on Enterprise and Express, express are mach more faster (100 times) Thanks for advises.

    Database database sql-server sysadmin performance question

  • Veeeeeeeeeery slow queries in MS SQL 2005
    3 3fonov

    I move this database to MS SQL Express and it's start working 30 times faster as i assumed it must. So problem somewhere in server configuration not database design. Thanks

    Database database sysadmin xml performance help

  • Veeeeeeeeeery slow queries in MS SQL 2005
    3 3fonov

    Thanks for help but... I try to run this on clean installation on empty tables and got this in Profiler: Print Screen. There is no triggers, compressed folders, and so on. Theres is selected a bit more complicated procedure, but as i think it must not take 3 seconds to run got it indexes or not. The same routines on MySQL server takes zero time and CPU perfomance. Thanks for advises.

    Database database sysadmin xml performance help

  • Veeeeeeeeeery slow queries in MS SQL 2005
    3 3fonov

    Yes it is. And it doesn't depends on table size or data size. When it's executed in Managment Studio with Client statistics everything is zero. Thank you for quick reply

    Database database sysadmin xml performance help

  • Veeeeeeeeeery slow queries in MS SQL 2005
    3 3fonov

    Hello all! I've got some problem. When i'm executing about 10 stored procedures it's tooks 5 second to complete. Here is procedures code: ALTER PROCEDURE [dbo].[update_source] -- Add the parameters for the stored procedure here @internal_id int, @parent_id int, @sstate tinyint, @title nvarchar(50), @rng decimal(4,2), @lat dbo.latitude, @lon dbo.longtitude, @course dbo.angle, @speed dbo.speed, @stype xml AS BEGIN SET NOCOUNT ON; DECLARE @source_id int; DECLARE @state int; SET @source_id = (SELECT source_id FROM sources WHERE internal_id = @internal_id); IF @source_id IS NULL BEGIN INSERT INTO sources (internal_id, parent_id, updated, sstate, title, rng, course, speed, stype,lat,lon) VALUES (@internal_id, @parent_id, getutcdate(), @sstate, @title, @rng, @course, @speed, @stype, @lat*100000000, @lon*10000000); SET @source_id = (SELECT source_id FROM sources WHERE internal_id = @internal_id); END ELSE SET @state = (SELECT sstate FROM sources WHERE source_id = @source_id); UPDATE sources SET parent_id = @parent_id, updated = getutcdate(), sstate = @sstate, title = @title, rng = @rng, course = @course, speed = @speed, stype = @stype, lat = @lat*100000000, lon = @lon*10000000 WHERE source_id = @source_id; INSERT INTO source_states (source_id, sstate, acquired) VALUES (@source_id, @sstate, getutcdate()); END and i'm execute it like this: EXEC update_source 2190074, 5, 1, N'2190074', 0,57.7386783333333,10.57468,0,0,N''; EXEC update_source 2573335, 5, 1, N'2573335', 0,63.8,9.73333333333333,0,0,N''; ..... ..... ..... EXEC update_source 2573105, 5, 1, N'2573105', 0,59.6166666666667,10.5166666666667,0,0,N''; EXEC update_source 2573235, 5, 1, N'2573235', 0,60.4,5.35,0,0,N''; I think that mistake not in my code but somewhere in server configuration. But i can't find it out. Thanks a lot!

    Database database sysadmin xml performance help
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups