473,320 Members | 2,097 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,320 software developers and data experts.

SS2000 500xSELECT on one table; how to speed it up??

Hi

I have a table (1 000 000) and I need to submit min 500 queries (each one is different). I'm using SS2000

Currently it takes 2min and I need it below 1 min.

Is is possible to create the table in memory on then submit all the queries?? would it be faster?? if yes how to do that??

Many thanks in advance.
Emil
Aug 11 '08 #1
4 1210
Stewart Ross
2,545 Expert Mod 2GB
Emsik1001, please do not duplicate your posts. This is the third post on this topic you have placed - one previous post was moved to the Access forum by a Moderator, you then placed another post (which I have deleted) in the Access forum (which, to explain the caption Forum Leader above is my home forum, not this one), and a third post in this forum (SQL Server).

As a full member of the site I am sure you are aware of the site rules on duplicate posting.

MODERATOR
Aug 11 '08 #2
I was advised to move my question to another forum (VB to Access)

and the SQL Server is a different one (at least for me).

Sorry for the unintentional duplicatations.
Aug 11 '08 #3
ck9663
2,878 Expert 2GB
There are a lot of factors to consider.

1. What are these queries? Just Data Access or Data Modifications?

2. Do you need any return values?

3. What are you using these for? Is there a front-end that process the results?

More details, please?

-- CK
Aug 11 '08 #4
Hi

The process is very simple:

1) a table with data (numeric only)

2) an xls file with 500 records where each row creates a unique SELECT statement which needs to be run on the table and for the same row in xls in the last column should be pasted the result of the SELECT statement.

I'm ok with outputing the results I just need to know if there is a better way of submitting 500 select statements on one table.

Currently 800 000 rows in the table aganst 500 unique select statements take 1:56min (without any modifications to the table yet I want to find a way to reduce this time).

I will give an example of the table row and select statement tonight.

Thanks for your help.
Aug 12 '08 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Chris Foster | last post by:
I am trying to implement a very fast queue using SQL Server. The queue table will contain tens of millions of records. The problem I have is the more records completed, the the slower it gets....
0
by: Randall Sell | last post by:
Hello all, I am migrating a Paradox application to SQL Server. My problem is that the existing Paradox table structure is limited. Correcting it will mean a re-write of the application (Delphi...
18
by: Jeff Boes | last post by:
I'm sure this is a concept that's been explored here. I have a table (fairly simple, just two columns, one of which is a 32-digit checksum) with several million rows (currently, about 7 million)....
15
by: kimi | last post by:
I have just started working on a project that is partially complete. It is an application that is using access to store test results. The test results are being stored in two Access 2000 databases....
21
by: Johan Tibell | last post by:
I would be grateful if someone had a minute or two to review my hash table implementation. It's not yet commented but hopefully it's short and idiomatic enough to be readable. Some of the code...
2
by: dgk | last post by:
My co-worker, no idiot, says that the tooltip in the system tray for the SS2000 icon usually shows the computer and server, but once in a while shows the password (two slashes and the password). ...
2
by: Wensui Liu | last post by:
Dear all, is there a way to create a 2-dimension-table-like object such that I can reference a whole column directly using something like : mytable.column1 ? by the way, can python be used...
7
by: Kamal | last post by:
Hello all, I have a very simple html table with collapsible rows and sorting capabilities. The collapsible row is hidden with css rule (display:none). When one clicks in the left of the...
139
by: ravi | last post by:
Hi can anybody tell me that which ds will be best suited to implement a hash table in C/C++ thanx. in advanced
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.