In my database when I fire query it takes 40 secs on 1 crore data, similar when I use join with other table then it take more time. I have taken care non cluster index such thing. But still I want to optimize my query, what other thing I need to take like buffer, disk size etc. I am not sure on this area.
View 11 RepliesI'm creating a web page that will show a form that allows a user to query a database and then page backwards and forwards through the data. In other words one record of the returned data will be displayed on the form and the user can move forward to display the next record or back to display the previous one.
My problem is that a large volume of data may be returned and I'm wondering the best way to keep this data between postbacks. I would think there would be too much data to use viewstate.
I have large volume of records in my database(70k).How do i handle with this kind of volume data in gridview. Is there any samples provided for this?
View 2 RepliesI'm developing a web app for which the client wants us to query their data as little as possible. The data will be coming from a Microsoft CRM instance.
So we've agreed that data will only be queried as and when it is needed, therefore if a web user wants to see a list of contacts (for example) that list is fetched into a local DataTable. Then if a new contact is created on the website the new contact is sent to CRM and added to the local DataTable at the same time. Likewise for edits.
If the user then looks at their contacts again the data will just come from the local DataTable.
I have a standard ASMX web service which uses a lock object to process the first request it receives and reject other requests that come in before processing completes. The web service is hosted on a Windows Server 2003 box with a single-core processor. To test whether this works as expected, I wrote a client that spawns 100 threads. Each thread makes an asynchronous POST call to the web server (i.e., HttpWebRequest.BeginGetResponse()). From my own logging, what I'm seeing on IIS is that two threads are spawned. Let's say thread IDs 1 and 7. Thread 1 is assigned a small number of requests. It accepts and processes them, one after another. Thread 7 is assigned a large number of requests. It rejects them. Does anyone have theories on the following: Why are two threads spawned? And not four or a hundred? Why does there seem to be thread discrimination? Thread 1 looks like it has control of the lock object at all times.
View 1 RepliesI'm having an issue sending large volumes of emails out from an ASP.Net application. I won't post the code, but instead explain what's going on. The code should send emails to 4000 recipients but seems to stall at 385/387.
The code creates the content for the email in a string.
It then selects a list of email address to send to.
Looping through the data via a datareader it picks out the email address and sends an email.
The email sending is done by a separate method which can handle failures and returns it's outcome.
As each record is sent I produce an XML node in an XML document to log each specific attempt to send.
The loop seems to end prematurely and the XML document is saved to disk.
Now I know the code works. I have run it locally using the same SMTP machine and it worked fine with 500 records. Granted there was less content, but I can't see how that would make any difference.
I don't think the page itself times out, but even if it did, I was sure .Net would continue processing the page, even if the user saw a page time out error.
How Does IIS Handle a Large Volume of Requests
View 2 RepliesI'm facing a problem in our current running application. There is a table in database which has 67 columns,among these 18 columns are nvarchar(max) datatype and contains 30K records. Problem is now that SELECT * FROM myTable it takes around 3 to 4 seconds. Which is degrading our application's performance.
View 12 RepliesI am trying to display this query result in an aspx page.
It is very slow in loading. Here is the query. The inner query inside the outer quesry is the problem.(Please see the underlined part in the query) - (If I remove that part it is very fast.)
select
top 500
--This column is the issue
,Governing_Class=( case when exists (select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.appid and tqc.class_code not in('8742' ,'8810','7380')
order by tqcm.premium_amt desc
)
then ( select top 1 tqc.class_code from
t_quote_class tqc
inner join t_quote_class_premium tqcm on tqc.class_code =tqcm.
class_code
where tqc.appid=pi.
appid
order by tqcm.premium_amt desc
)
......... From tables
The below SQL query is running extremely slow. Im using this query on other tables and its processing about 5 rows per second. The below version is running 1 row every 10 seconds when @SQLNew is executed.
[Code]....
I've got this query UPDATE linkeddb...table SET field1 = 'Y' WHERE column1 = '1234' This takes 23 seconds to select and update one row But if I use openquery (which I don't want to) then it only takes half a second.
The reason I don't want to use openquery is so I can add parameters to my query securely and be safe from SQL injections. Does anyone know of any reason for it to be running so slowly?
I have a user control that is common to the application. It searchs for lakhs of Items in one go from the db and I set the selected Items in a list in a session to pass on to the pages that use it. Hence making the application a tad slower. The gridview that contains the Items should have sorting, page indexing. What according to u,I should do to enhance the application's performance ?
View 1 RepliesOne of my peer wrote a query based on multiple tables using joins. One of the table is in a different database The query was taking much time
1. Create an SP
2. Create a temp table and copy all records from the external db
3. Avoid using Left Join as much as possible and use Inner Join
4. Create and use indexes
5. Remove tables/columns that are not necessary
In this scenario, I would like to suggest to use Covering Index, but how can it be created for multiple tables and a temp table?
I have an asp.net web page to serve large file downloads to users.
The page is hosted on IIS7, Windows Server 2008.
The strange thing is that users can download at good speeds (2MB/s) when I don't add a content-length response header but as soon as I add this header, download speed drops to somewhere around 35kbps/s.
This is the code:
[code]...
Of course I can leave the content-length out but the user will not know how big the file is and how long the download will take...which is annoying.
When we include Javascript files in our aspx files. either we write all the Javascript code in the Head section of aspx or we link to an external Javascript file.
So when the clinet makes a call to that page. Does that mean that all the Javascript will be loaded on the client side?
If that is the case then does not that mean that it will slow down the loading of page as all the Javascript has to be loaded on the client machine?
I have a query string with huge params (greater than 2 KB) and i have to pass it to another page in which there is an email component. I have to send the email with a link (URL) that has the query string so that user can click on the link and access the page.
View 4 RepliesI built an asp.net application using web developer express 2008 and sql express2008. The live version hosted on Godaddy, for the most part is working well. However, occasionally the users are reporting an error when the user volume is high.
Here is part of my web.config code:
<customErrors defaultRedirect="/Error/error.htm" mode="On">
<error statusCode="400" redirect="/Error/BadRequest.htm"/>
<error statusCode="404" redirect="/Error/NotFound.htm"/>
<error statusCode="408" redirect="/Error/TimeOut.htm"/>
</customErrors>
I have seen the other error pages work correctly and the error I am referring to above is the default error.It is possible that up to 10 users opening the same database table at the same time might be the problem? Would this be a potential cause of my unknown error? And if so what can I do about it?
im using an access database with less than 50.000 records on a single table, no relations.
ive put the following code inside a two for cycles as per the respective variables (i, j) the connection is opened outside the outer cycle and closed after it, im holding the connection open to save up on open/close time and im using OleDB thinking it would be faster than ODBC. The ds fill operation takes nearly 3 seconds in debug mode, the total process will require almost 4 hours. How is it possible to speed it up?
[Code]....
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.
I have 2 tables with Primery Key in both table and 700k in each tables and i am direct executing following Query in SQL Server 2008
[Code]....
Its speed very slow and then timedout error. My system configuration is good and i am not executing it online but offline on my laptop.
i want to to sotre large amount of character in one field of a table i use text-nvarchar(max) and but it show me this exception
(String or binary data would be truncated The statement has been terminated.) I know that text and nvarchar can store 8000 character
I have a DTS script which transforms a Tab delimited text file to a table. I get the following error when trying to transform the data of a field that is greater than 255 chars:
[Code]....
I have seen this issue with importing from Excel with the jet 4.0 engine, however I am importing a text file.
I have an asmx web service I am "Upgrading" to WCF. It's function is to pass a DataTable to the Remote Server. It works fine as long as the dataset contains under 20 records(more or less). Anything greater than that returns the error:
The remote server returned an unexpected response: (400) Bad Request
Everything I searched on the web says I need to increase things like maxBufferSize in my Web.Config File, but like so many others, it has produced no results. This seems like it should be a simple fix.
I am using VS 2010 on Windows 7. All Development and debugging is being done on the localhost. What I currently have for my web.Config file is below:
[Code]....
I have contact mails large than 700.000 Mails and i want to insert them in sqlserver using c# in a few minutes not hours i know that pre impossible but , i know there`s way to do it
View 4 RepliesI want to transfer the data from one server to another by sql query. I want query. I dont know how to write?
View 2 Replies