C# .NET - my windows application run slow after fetchting 250 records
Asked By pankaj singh
03-Feb-12 06:27 AM
Hi expert
I made a windows application that fetch images according to number , It run good till 250 or 200, after fetching 200 records it get slower and slower. I think it is memory management issues how to resolve it .please help me.
dipa ahuja replied to pankaj singh
To increase the speed of SQL SELECT query, you can analyze the following issues:
► Available indexes for conditions from WHERE clause
► Rewriting a query with OR conditions as a UNION
► Available indexes for JOIN conditions
► Available indexes for ORDER BY clause
► Available indexes for GROUP BY clause
► Select from in-memory tables
► SELECT INTO vs INSERT SELECT
pankaj singh replied to dipa ahuja
I am using access 2003 as a data base is it any process that release memory after each record fetch
MSDN collection, NOT a retail version. When I look at the server's PROPERTIES, and select the MEMORY options and view the help file, it makes mention of Dynamic memory configuration. The memory options screen, however, doesn't have any dynamic memory configurations. I assume this is because I'm using the MSDN copy and not a I don't use standard edition. But I'd try to change the 'max server memory' setting from a query window using sp_configure as follows: sp_configure 'max server memory', 1500 - - or soem other value go reconfigure with override go and check if the setting
SQL Server Memory Usage HELP! (Counter Memory Manager / Total Server Memory (KB) SQL Server I am running Windows 2003 SP2 x64 with SQL Server 2005 X64. Does the counter SQLServer:Memory Manager / Total Server Memory (KB) show the amount of physical memory is use by SQL? Why isn't this value reported by the sqlservr.exe working Server usage b / c it continues to grow and the system which has 34GB of memory generally runs with 300MB available. SQL Server Discussions SQL Server (1) Megan SELECT * FROM sys.dm_os_performance_counters WHERE counter_name = 'Total Server Memory (KB)' OR counter_name = 'Target Server Memory (KB
Contact list with specific contacts iin each. How may I set up so when I select a specific contacts list I ONLY see those contacts listed. Now when I select I get all the people in ALL my contacts lists and have to select from memory. - - Bernie Windows Vista Mail Discussions BernieJ (1) VistaRookie (1) FORUMS (1) VISTA (1) VanderMolen (1 Contact list with specific contacts iin each. How may I set up so when I select a specific contacts list I ONLY see those contacts listed.
How to Recover Photos from Memory Stick? Memory Stick is a removable flash memory card format launched by Sony. It includes a wide range of formats like memory stick, memory stick select, PRO, Duo, PRO Duo, XC and M2. For the large storage capacity as well as fast file transfer speed, memory sticks are widely applied in Sony’s digital products including Sony digital cameras, cell phones camera or mobile phones, we may come across the scenario of deleting photos or formatting memory stick, then is memory stick recovery possible? Like other storage card, when you delete pictures
Script for finding the CPU and Memory information .NET Framework Hi all, Can someone help me in finding the cpu family, cpu speed, cpu count, total memory, maximum memory capable, memory count, memory speed for a remote server? A powershell script which can find all the above details Powershell Discussions CPUget (1) ProcessorType (1) Sekhar (1) Wmiobject (1) For CPU get-wmiobject Win32_Processor | select Architecture, Caption, Name, Version, Manufacturer, ProcessorType To get full properties view get-wmiobject Win32_Processor | format you very much Shay. It worked for me. keywords: Script, for, finding, the, CPU, and, Memory, information description: Hi all, Can someone help me in finding the cpu family, cpu speed, cpu count, total memory, maximum memory capable, memory count, memory speed for a re