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

SQL Sub Queries?

Hi,

I am using the ODBC connection with Sage Accounts to print barcode labels. It is very slow and I want to try and speed up the sql I am using. The database has over 6000 items, but only 3000 are in use at the moment (cannot delete them). I have a variable "QTY_REORDER_LEVEL" which when 0 means its not in use.

I was hoping I could somehow run through the db stripping old out first and then doing the barcode search.

Would this make things faster? And if so/or not, could you give me some ideas.

My current sql string is:

Expand|Select|Wrap|Line Numbers
  1. SELECT DESCRIPTION, SALES_PRICE, TAX_CODE
  2. FROM STOCK
  3. WHERE QTY_REORDER_LEVEL <> '0' AND STOCK_CODE = :VarBarcode
  4.  
Thanks,
Paul.
Sep 29 '07 #1
2 1148
azimmer
200 Expert 100+
Hi,

I am using the ODBC connection with Sage Accounts to print barcode labels. It is very slow and I want to try and speed up the sql I am using. The database has over 6000 items, but only 3000 are in use at the moment (cannot delete them). I have a variable "QTY_REORDER_LEVEL" which when 0 means its not in use.

I was hoping I could somehow run through the db stripping old out first and then doing the barcode search.

Would this make things faster? And if so/or not, could you give me some ideas.

My current sql string is:

Expand|Select|Wrap|Line Numbers
  1. SELECT DESCRIPTION, SALES_PRICE, TAX_CODE
  2. FROM STOCK
  3. WHERE QTY_REORDER_LEVEL <> '0' AND STOCK_CODE = :VarBarcode
  4.  
Thanks,
Paul.
Not necessarily. I suggest you put indices on QTY_REORDER_LEVEL and STOCK_CODE.
Sep 29 '07 #2
Hi,

Thanks for your advice, I am going to go and try it.

Paul.
Oct 2 '07 #3

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

Similar topics

6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
5
by: WertmanTheMad | last post by:
Ive been playing with this for a few days and thought I might thow it out for seggestions. I have Several Queries that need counts returned The Queries are Mutually Exclusive meaning whatever...
1
by: Roger Green | last post by:
I have inherited a complex database that has many dozens of queries that derive data from a people table. I now need to be able to run these queries (from within a significant number of forms)...
9
by: Dom Boyce | last post by:
Hi First up, I am using MS Access 2002. I have a database which records analyst rating changes for a list of companies on a daily basis. Unfortunately, the database has been set up (by my...
3
by: NeilAnderson | last post by:
I'm a fairly new user of access & I've never had any training, so I'm wondering if I'm doing the right thing here, or if it matter at all. I'm building a database for room booking purposes and I'm...
5
by: Jerry Hull | last post by:
I'm working with a database developed by an untrained person over several years - and on a network that has recently been upgraded with a new server installed and MS office upgraded from 2K (I...
0
by: MHenry | last post by:
Hi, I know virtually nothing about creating Macros in Access. I would appreciate some help in creating a Macro or Macros that automatically run(s) 14 Queries (three Make Table Queries, and 11...
44
by: Greg Strong | last post by:
Hello All, Is it better to create a query in DAO where a report has 4 sub-reports each of whose record source is a query created at runtime and everything is in 1 MDB file? From what I've...
1
by: loosecannon_1 | last post by:
Hello everyone, I am hoping someone can help me with this problem. I will say up front that I am not a SQL Server DBA, I am a developer. I have an application that sends about 25 simultaneous...
5
by: marshmallowww | last post by:
I have an Access 2000 mde application which uses ADO and pass through queries to communicate with SQL Server 7, 2000 or 2005. Some of my customers, especially those with SQL Server 2005, have had...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...
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.