selecting ? selecting of 1., 2. , 3., 4., 5., 6. is slow (1-3 second) then selecting of 7.,8.,9. go on is so fast (0.1 second or more fast).. how can i get fast for selecting of 1., 2. , 3., 4., 5., 6

hello friends

selecting of 1., 2. , 3., 4.(sometime even 5., 6.) is slow (1-3 second) then selecting of 7.,8.,9.(sometimes 5., 6.,) go on is so fast (0.1 second or more fast).. how can i get fast for selecting of 1., 2. , 3., 4., 5., 6. is slow ?? recordcount is almost 1.050.000.. i do selecting 1.2.3. go on same page with treeview1.. treeview1 in masterpage.master..

gridview1 and datasource1 are in pagelist.aspx (it connets datasource1)..productnumber is primarykey for index.. kategori, kategori1 and kategori2, price, datemin are index from keys/index in table1 (right clicking menu).. they seems in gridview1 :)

cheers

Page Load 

If Request("arama1") IsNot Nothing Then

TextBox1.Text = Request("arama1")

aramal1.Text = Request("arama1")

End If

If Request("arama2") IsNot Nothing Then

TextBox2.Text = Request("arama2")

aramal2.Text = Request("arama2")

End If

If Request("arama3") IsNot Nothing Then

aramal3.Text = Request("arama3")

TextBox3.Text = Request("arama3")

End If

End If

'Dim cn As New SqlConnection(ConfigurationManager.ConnectionStrings("ConnectionString").ToString)

'cn.Open()

Dim yeni1 As String

If aramal3.Text = "" And aramal2.Text = "" Then

yeni1 = "Select * from urunlistesi where (kategori=@kategori)"

End If

If aramal3.Text = "" Then

yeni1 = "Select * from urunlistesi where (kategori=@kategori) and (kategori1=@kategori1)"

End If

If aramal3.Text <> "" And aramal2.Text <> "" And aramal1.Text <> "" Then

yeni1 = "Select * from urunlistesi where (kategori=@kategori) and (kategori1=@kategori1) and (kategori2=@kategori2)"

End If

SqlDataSource1.SelectCommand = yeni1

SqlDataSource1.SelectParameters.Add(
"kategori", aramal1.Text)

SqlDataSource1.SelectParameters.Add("kategori1", aramal2.Text)

SqlDataSource1.SelectParameters.Add("kategori2", aramal3.Text)


Mark as me if my question or my answer can be helpful for you :)
0
oguzkaygun
6/26/2008 12:06:38 PM
asp.net.presentation-controls 72751 articles. 3 followers. Follow

1 Replies
3203 Views

Similar Articles

[PageSpeed] 5

It sounds like you are are talking about situations where the first couple of apges you pull up run very slowly, then later they run much quicker.  My guess you are seeing this either on a low volume website, or one you development machine.  If the former, you can tune the site in IIS for a lower volume, which should alleivate some of this issue.  If the latter, the you can try building the site before running.

Think of it like driving a car.  When you start from a stop, or slow speed, it take a little extra effort to get going.  Once you are up to speed it is very easy to maintain that speed.  The same idea applies here.  When you first connect to a database, a connection needs to be made.  When you are done with that connection, it is kept alive for reuse later, and can be used much faster than the first time.    In terms of page caching and just-in-time compiling of aspx page, roughly the same holds true.


Failure is always an option. Avoid situations where it is the only option.
0
grahamlower
6/27/2008 9:21:10 PM
Reply:

Similar Artilces:

[ANN] Release of Bugzilla 4.3.1, 4.2.1, 4.0.6, and 3.6.9
Today we are releasing 4.2.1, 4.0.6, 3.6.9, and the unstable development snapshot 4.3.1. All of today's releases contain security fixes. We recommend all Bugzilla administrators to read the Security Advisory linked below. Bugzilla 4.2.1 is our latest stable release. It contains various useful bug fixes, performance improvements and security fixes for the 4.2 branch. Bugzilla 4.0.6 and 3.6.9 are security updates for the 4.0 branch and the 3.6 branch, respectively. Note that 4.3.1 is an unstable development release and should not be used in production environ...

[ANN] Release of Bugzilla 4.1.2, 4.0.1, 3.6.5, and 3.4.11
Today we are releasing 4.0.1, 3.6.5, 3.4.11, and the unstable development snapshot 4.1.2. Many users had difficulty installing Bugzilla 4.0, 3.6.4, and 3.4.10, due to a bug related to the "Math::Random::Secure" library. These releases fix that bug among other issues. Note that 4.1.2 is an unstable development release and should not be used in production environments. However, we are getting very close to feature freeze for 4.2, so now is the time to give us feedback on 4.1.2 if you want its behavior to change significantly before we release. Download -------...

Smoke [5.6.2] maint-5.6-3-g2bce232 FAIL(m) linux 3.1.0-1-amd64 [debian] (x86_64/8 cpu) #2
Automated smoke report for 5.6.2 patch 2bce2321552345ccb985b6a4b87542c3eaefbac5 maint-5.6-3-g2bce232 gateway: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz (GenuineIntel 3392MHz) (x86_64/8 cpu) on linux - 3.1.0-1-amd64 [debian] using cc version 4.6.2 smoketime 21 seconds (average 21 seconds) Summary: FAIL(m) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t =...

Testing 1 2 3 4 5 5 4 3 2 1
The quick brown fox jumped over the lazy dog's back 1234567890 times. RYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRY SGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSG -- Ed http://mysite.verizon.net/vze1zhwu/ Powered by SeaMonkey: http://www.seamonkey-project.org/ On 10/28/2010 6:07 AM, W3BNR wrote: > > The quick brown fox jumped over the lazy dog's back 1234567890 times. > RYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRYRY > SGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSGSG &g...

Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.4) Gecko/20100413 Firefox/3.6.4
Name: Product: Firefox Summary: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.4) Gecko/20100413 Firefox/3.6.4 Comments: tell me that there is update awaiting after downloded, can't install it integrity not checked after few time, fire fox stop working Browser Details: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.2.4) Gecko/20100413 Firefox/3.6.4 From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if you wish to provide one you must BCC (not CC) the sender for them to see it. ...

Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729
Name: Patrick Email: plakt97312atmsndotcom Product: Firefox Summary: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729 Comments: Firefox 3.5.7 running on HP Laptop hp G60, with Vista. When opening various websites, Firefox has functionality problems, specifically the minimize, size window, or close buttons in the upper left corner do not work. The scroll bar still works. Also, if I go to a website (i.e. Hotels.com AAA.com, etc.) and use a calendar at the site to select a date, Firefox freezes some of the time and...

Mozilla/5.0 (Windows; U; Windows NT 6.0; de; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 GTB6 (.NET CLR 3.5.30729)
Name: hajori Email: hajoriataondotat Product: Firefox Summary: Mozilla/5.0 (Windows; U; Windows NT 6.0; de; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 GTB6 (.NET CLR 3.5.30729) Comments: (Deutsch) Seit den Update braucht Firefox 5 Minuten um eine neue Seite zu laden das kann doch nicht normal sein ?????????? Oder ? Browser Details: Mozilla/5.0 (Windows; U; Windows NT 6.0; de; rv:1.9.1.7) Gecko/20091221 Firefox/3.5.7 GTB6 (.NET CLR 3.5.30729) From URL: http://hendrix.mozilla.org/ Note to readers: Hendrix gives no expectation of a response to this feedback but if you wis...

[ANN] Release of Bugzilla 3.2.7, 3.4.7, 3.6.1, and 3.7.1
Today we have four new releases! One new development snapshot (3.7.1), two new stable releases (3.6.1 and 3.4.7) and one update for the legacy 3.2 branch (3.2.7). Bugzilla 3.6.1 is our latest stable release. It contains some significant bug fixes for the 3.6 branch. Bugzilla 3.4.7 is the last bug-fix release for the 3.4 series. After this, there will only be additional 3.4 releases if there are security issues discovered in the 3.4 series. Bugzilla 3.2.7 is a security update for the 3.2 branch. Bugzilla 3.7.1 is our first unstable development release on the road to ...

Smoke [5.6.2] maint-5.6-3-g2bce232 FAIL(m) linux 3.1.0-1-amd64 [debian] (x86_64/8 cpu)
Automated smoke report for 5.6.2 patch 2bce2321552345ccb985b6a4b87542c3eaefbac5 maint-5.6-3-g2bce232 gateway: Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz (GenuineIntel 3392MHz) (x86_64/8 cpu) on linux - 3.1.0-1-amd64 [debian] using cc version 4.6.2 smoketime 20 seconds (average 20 seconds) Summary: FAIL(m) O = OK F = Failure(s), extended report at the bottom X = Failure(s) under TEST but not under harness ? = still running or test results not (yet) available Build failures during: - = unknown or N/A c = Configure, m = make, M = make (after miniperl), t =...

From 2.1.2 to 3.1 or 2.1.2 to 3.0.13 to 3.1
I'm checking back in after being away for a couple of months and I missed the 3.1 release. I can't seem to find any info on what's new in 3.1 and also what the upgrade path should be. So, is the recommended path for upgrading from v 2.1.2 to go directly to 3.1 or do I need to go to 3.0.13 first? Are there any big issues in 3.1 that make it a "gotta have it" version?I did a couple of 2.1.2 to 3.0.12 upgrades but haven't upgraded to or tested 3.1 yet. I have one 2.1.2 site that is commercial and I need it to be down as little time as possible. It also has a lot of third party modules...

kdesvn 1.0.5 or 1.0.6 for KDE 3.5 subversion 1.6.3?
Installed: Code: -------------------- Subversion 1.6.3-1.1 KDE 3.5.10 -------------------- I upgraded subversion to 1.6.3, and wanted to make sure I had the latest kdesvn for KDE 3.5 and subversion 1.6.3. I went to kdesvn support site but it wasn't clear if 1.0.5 was sufficient for subversion 1.6, so I downloaded kdesvn 1.0.6 and built it myself (previously 1.0.5 had come from opensuse). Everything looked okay, but... When I click on the Help | Info about kdesvn part I see: Code: -------------------- Built with subversion library 1.4.4 Running ...

c1 1.3.6 OK or is 1.3.5/1.3.4 better?
I'm upgrading my system, most of our c1 versions are now at 1 1.3.6. Is that OK or is 1.3.5/1.3.4 better? - JD I am very happy with 1.3.6, but there were issues (resolved with the latest patches) with ZfD 4.01 Tim On Wed, 10 Mar 2004 19:15:22 GMT, "j d" <j d@none.org> wrote: >I'm upgrading my system, most of our c1 versions are now at 1 1.3.6. Is >that OK or is 1.3.5/1.3.4 better? > > > >- JD > No Direct e-Mail Please! -- **************** Tim Heywood Independent Consultant Scotland (God's Country) No...

SQLRemote Problem with 7.0.2-1 and 6.0.2-1 on Linux [ASE 11.9.2-3 and ASE 12.5 eval]
Hi all I got the following problems using sql-remote. on ASE 12.5 eval: I got the following RPMs installed on RedHat Linux 7.2 - Kernel 2.4.17 - glibc-2.2.4 sybase-ase-12.5-3.i386.rpm sybase-common-12.5-3.i386.rpm sybase-openclient-12.5-3.i386.rpm sybase-sqlremote-7.0.2-1.i386.rpm After the execution of ssxtract or ssremote I got an error like: ../ssxtract: /opt/sybase-12.5/SQLRemote/lib/libsstasks7_r.so: version `libdbtasks7_r.so' not found (required by ./ssxtract) The file libsstasks7_r.so exists and the path is correctly specified in /etc/ld.so.conf. There'...

Convert a string like "1,2,3,4,5,6,7,8,9,11,12,13,15" to "1 to 9, 11 to 13, 15"
I have a database field which holds serial numbers as a comma separated string which has already been checked for duplicates and sorted. This field can be very large when there are many serial numbers. In order to save screen space I would like to display ranges of sequential numbers by showing the first and last number with "to" between them. This may happen a few times in one string. I've tried fiddling around putting the string into an arraylist but my mind goes blank when trying to work out how to know if a number is the next in sequence when moving through the arraylist. ...

Web resources about - selecting ? selecting of 1., 2. , 3., 4., 5., 6. is slow (1-3 second) then selecting of 7.,8.,9. go on is so fast (0.1 second or more fast).. how can i get fast for selecting of 1., 2. , 3., 4., 5., 6 - asp.net.presentation-controls

Consultation Document on the Methods for Selecting the Chief Executive and for Forming the LegCo in 2012 ...
The " Consultation Document on the Methods for Selecting the Chief Executive and for Forming the LegCo in 2012 " was a document published on ...

Voting Machine Caught on Camera Casting Ballot for Democrat when Selecting Republican - YouTube
**UPDATE.... I've heard many reports that this is "just a calibration issue." I will say this... when I went to page 2 and began voting for city ...

Selecting The Right Jeans
Fit, style, cut, colour and wash all factor into the pursuit for great denim.

Clock ticking on selecting successor to Leigh Clifford at Qantas
With Qantas on course to chalk up its largest annual profit since 2008, the question now is whether chairman Leigh Clifford is looking to hang ...

Why are the reserves selecting the team?
Backbenchers are the reserves of the parliamentary system. They are newcomers.

Jackie French: Why selecting the right place for your plants is important
The secret of growing anything easily is to choose the best spot for what you want to grow.

Netflix turns to pirates when selecting new shows
Imagine the surprise, then, when the popular video streaming site admitted that it actually turns to torrenters for inspiration. "With the purchase ...

Boston Marathon bombing trial: Judge, lawyers face challenges in selecting jurors - CTV News
As the second phase of jury selection began in the federal death penalty trial of Boston Marathon bombing suspect Dzhokhar Tsarnaev, it immediately ...

Selecting cabinet one of first orders of business for Trudeau
One of the first orders of business for any new prime minister is picking a cabinet. Who is likely to make the cut?

Agile Analysis, Self-Selecting Teams, TDD & BDD in Methods & Tools Winter 2014 issue
... for software developers, testers and project managers – has just published its Winter 2014 issue that discusses Agile Analysis, Self-Selecting ...

Resources last updated: 1/8/2016 10:03:31 PM