473,322 Members | 1,523 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

speed problem

I have about 50000 records in table in SQL. Which is the fastes way to
display data on form. I had used DataReader & litview but it takes 20
seconds or more to populated data. Any suggestions?
thx
Nov 21 '05 #1
5 1025
Hi,

How many of the 50000 records do you think the user is going to look
at?

Ken
---------------------------------
"dzemo" <dz***@wizard.ba> wrote in message
news:us**************@TK2MSFTNGP11.phx.gbl...
I have about 50000 records in table in SQL. Which is the fastes way to
display data on form. I had used DataReader & litview but it takes 20
seconds or more to populated data. Any suggestions?
thx

Nov 21 '05 #2

August 7, 2004

You could use user input to query the database for only
certain items
or rows that have certain values in their columns. Your code could
look
something like this:

dim querystring as string
querystring = "SELECT * FROM DATABASE WHERE columnname='" & _
userinput & "'"

dim cmd as new Data.SqlClient.SqlCommand(querystring, connection)

dim reader as new data.sqlclient.sqldatareader
connection.open
reader = cmd.executereader
connection.close

You can then use the reader to create rows in your datagrid. Be very
careful of SQL Injection attacks!!!!!!!!!!! You might use regular
expressions
to check the user input. That then brings up the subject of
canonicalization
issues. Good luck!
Joseph
"dzemo" wrote:
I have about 50000 records in table in SQL. Which is the fastes way to
display data on form. I had used DataReader & litview but it takes 20
seconds or more to populated data. Any suggestions?
thx

Nov 21 '05 #3
well it a list of a pacients in one hospital and i dont have any idea which
doctor is going to see of them. Maybe sat before a form to ask 3 letters of
last name or somethink like that. But generaly which is the fastes way to
read that much data and in which control to display them

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:e2**************@TK2MSFTNGP11.phx.gbl...
Hi,

How many of the 50000 records do you think the user is going to look at?

Ken
---------------------------------
"dzemo" <dz***@wizard.ba> wrote in message
news:us**************@TK2MSFTNGP11.phx.gbl...
I have about 50000 records in table in SQL. Which is the fastes way to
display data on form. I had used DataReader & litview but it takes 20
seconds or more to populated data. Any suggestions?
thx

Nov 21 '05 #4
"dzemo" <dz***@wizard.ba> wrote in news:usGKLcHfEHA.3632
@TK2MSFTNGP11.phx.gbl:
I have about 50000 records in table in SQL.


Try taking a look at the 50,000 records.

--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/
Nov 21 '05 #5
Hi,

It would better to load the data on demand rather than listing 50000
records. When ever possible try using a stored procedure to get the data
because it is quicker.

Ken
-------------------
"dzemo" <dz***@wizard.ba> wrote in message
news:Oh****************@tk2msftngp13.phx.gbl...
well it a list of a pacients in one hospital and i dont have any idea which
doctor is going to see of them. Maybe sat before a form to ask 3 letters of
last name or somethink like that. But generaly which is the fastes way to
read that much data and in which control to display them

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:e2**************@TK2MSFTNGP11.phx.gbl...
Hi,

How many of the 50000 records do you think the user is going to look at?

Ken
---------------------------------
"dzemo" <dz***@wizard.ba> wrote in message
news:us**************@TK2MSFTNGP11.phx.gbl...
I have about 50000 records in table in SQL. Which is the fastes way to
display data on form. I had used DataReader & litview but it takes 20
seconds or more to populated data. Any suggestions?
thx


Nov 21 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

34
by: Jacek Generowicz | last post by:
I have a program in which I make very good use of a memoizer: def memoize(callable): cache = {} def proxy(*args): try: return cache except KeyError: return cache.setdefault(args,...
52
by: Neuruss | last post by:
It seems there are quite a few projects aimed to improve Python's speed and, therefore, eliminate its main limitation for mainstream acceptance. I just wonder what do you all think? Will Python...
4
by: Lost Bits | last post by:
Hello there C++ pros.. Well, I have recently redesigned an already existing piece of code that someone else designed - its just a search algorithm they developed, and has to perfomr millions of...
60
by: Neil | last post by:
I have a situation with an ODBC linked view in an Access 2000 MDB with a SQL 7 back end. The view is scrolling very slowly. However, if I open the view in an ADP file, it scrolls quickly. I...
2
by: Roy Gourgi | last post by:
Hi, My program seems to slow down drastically because as I fill my array and table with many values, the program suffers tremendously. The first thing my program does is to search the jagged...
9
by: burningsunorama | last post by:
Hi guys! This is maybe a too 'academic problem', but I would like to hear your opinions, something like pros and cons for each approach.... ... Recently we've had at work a little talk about the...
2
by: Mike Kober | last post by:
I am having issues with the File Upload control for sending files to the server via HTTP. The speed of the upload is often between 20kbs and 40kbs. If I use the LAN at work to the server, it...
6
by: Jassim Rahma | last post by:
I want to detect the internet speed using C# to show the user on what speed he's connecting to internet?
11
by: kyosohma | last post by:
Hi, We use a script here at work that runs whenever someone logs into their machine that logs various bits of information to a database. One of those bits is the CPU's model and speed. While...
4
by: nestle | last post by:
I have DSL with a download speed of 32MB/s and an upload speed of 8MB/s(according to my ISP), and I am using a router. My upload speed is always between 8MB/s and 9MB/s(which is above the max upload...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.