DataSource Controls :: Taking Long Time To Import Data From Csv To Sql Server 2005?
Feb 20, 2010
I have an application which imports data from csv to sql server 2005. It is taking long time to import data from csv to sql server 2005. it has a timer. on tick of timer, I am checking if current rown in csv exists in database. If it exists, It is not added to sql server otherwise, It is added that row to sql server 2005. Also, In page load, It checks on each tick, whether user is logged in or not. it adds value to log file that user is logged in. How can I optimize this ?
I am making some application in asp.net 1.1 in that I am displaying data in datagrid from database. In data grid first column is of check box and radio button and in the last column we have text box now thing is that when i click on check box crosponding textbox we fill some figure and at the end we press calculate button to get total. After getting total we have to press continue button to go next step
But suppose if some body remove that check the we should press calculate button or chnage some figure in the text box then we should press calculate button again to recalculate. for that i kept autopost back on check box oncheckedchanged event and text box ontextchanged event and hide continue button so user will click calcutae button abd then continue button will re-apper
Problem it that it taking too much refresh and taking long time. So was lloking for some ajax method to use in my application.
I have a big form in which i have almost 10 update panels. some are having updatemode = conditional and others are always. Now by default when that page is opened i only show one dropdownlist.When that project dropdownlist (from which i populate the rest of the elements in my page) value is changed by user it takes long time to load the other elements. Also the other gridview which is also surrounded by update panel and mode in conditional takes long time to show edititemtemplate controls in edit mode.
I am unable to trace the reason behing delay. Few days ago it was working fine and fast but now it is slow.
I have tested my pages in Firefox & IE and looking at Firebug in Firefox for some reason some images are taking a long time to load. They are not very big in comparison to the ones which are loading quicker.
Attached is a screenshot of Firebug.
I especially notice it in IE with the progress bar at the bottom of the page, it just sits there saying loading image...
Could it be the path or something which is http://localhost:49211/Content/_layout/images/bg-footer.png for example
Whenever I add an entry to the Hosts file on Windows, it takes a long time for the change to take place? I have tested using Firefox and IE and it seems to take around 5 minutes on both of them before the new IP/Domain entry on Hosts is recognised.
Is there anything I can do to overcome this? Perhaps "refreshing" the cache in some way? ipconfig /flushdns doesn't work.
When I Publish my website it takes around an hour and a half. This is publishing to a directory on my local machine, it is not FTP'ing to a remote server. The build seems to take about an hour (when I build without publishing it is noticeably slow, but 5 minutes slow, not an hour), then the publish seems to take a further half an hour.
what could be causing this and how I can improve this? This obviously causes issues when I make a change (I'm constantly updating the site) as I need to wait for an hour an a half. I'm considering not precompiling the site now and simply uploading the .aspx and .cs files direct to the server as this is unmanageable for me.
At work I'm tryhing to upgrade an ASP.NET 2.0 app (which we wrote using VB.NET 2005) to ASP.NET 4.0. I had a few problems during the upgrade, but eventually worked them all out. At the end of the day I decided to give it a quick compile and see if I'd get the start page, so I hit F5 in VS 2010. I left it that way, and man was it acting weird. VS 2010 wasn't responding to anything. If I hovered the mouse over VS 2010's minimize or close buttons, in the upper right corner, then those buttons were flashing very rapidly. I'm not sure what was going on. After waiting 15 minutes to see if it would come up, I decided to try clicking on the close button. Nothing happened. Eventually, I had to leave (I take public transit, and I have to leave when the bus comes)But what I want to know is this, is this pretty standard behavior? Does it normally take this long to do this? This website is of modest size (<100 pages).
(Later) When I came into work today, 8 hours later, VS 2010 was still doing whatever the heck it was doing, but basically it wasn't responding to anything.
I am working on a website hosted with GoDaddy, SQL Server 2005. I have a table in my SQL Server database with a full-text index. On my website, a user can type in search terms and the terms are then passed to a stored procedure in the database which performs the search. The first search takes about 45 seconds to get results. Subsequent searches return results immediately. I found a description of this problem in a Microsoft knowledgebase article:http://support.microsoft.com/kb/915850/en-usGoDaddy tech support says I need to purchase a dedicated server to make the changes suggested in this article.Surely there is some other solution. Does anyone know how to avoid this delay without changing the server configuration?
I'm using data access block [URL] in asp.net 3.5. Back end is sql server 2005. It's working fine and returns result instantly for all DB calls. But, I've a problem with one SP. When I call it, executereader is taking too much time. In few cases, it is executed. And sometimes I get the Time out error. I run the same SP in sql server. It returns 9000 rows in 3 seconds.
i had the sql 2008 enterprise and i want to go back to sql server 2005 because in 2008 i created new database but when i did some changes in the table , it gave me an eror that i cant save thins and i need to creat new one if some one know what i'm talking aboutif not i need the sql server installation tutorial i tried by myself but probebly i did it wrong and now i cant connect well to the sql
I want to upload excel file using SqlBulkCopy into a SQL Server 2005 table. My excel file size is 43MB. When I am uploading this file it will display error message that The request filtering module is configured to deny a request that exceeds the request content length.My web.config file setting is
1)How to convert 64base string to binary in asp.net and store into sql server.
2)when i convert 64 base string into binary & try to store it into database then it has taken so much tiime to insert. The size of 64base string is 1.5MB. and when i converted to binary then the size is 11MB.so the best way to insert the binary data into sql server. The data type of column is varbinary(MAX).
3)How can i insert the varbinary data into sql server uisng asp.net?
I want to generate 30,000 cards and each card must be duplicate check with database. In my card, there are 2 things. Serial No and CardID. If any card already exists then I generate another card id but with the same serial no.
So how faster way I can generate 30,000 card with duplicate check? Which one I have made application, it takes about 25 minutes to insert.
We would like to benchmark the asp.net c# app to see which part may be taking too long. How would you do this? We need to check:
1. The query on the server side. 2.The summarization that the app code is doing once it gets all the data. 3. Add in logging statements at various points in the code so we can see how long each step is taking 4. Time the sql query to see how long that takes.