I currently use an SQL command line that utilizes parallel threads. ex.
select /*+ PARALLEL (ACCOUNT 20) */ Account_ID, Customer_Name, Add_Date from Customer_Info. By running this query using parallel threads, it returns results in less than one minute. If I did not use the parallel threads, it would take 20 minutes or more to run. This command is run using SQL+
Is it possible to use Parallel thread processing in Access? If so, how?
4  4183  PEB 1,418
Expert 1GB
I think that no! If there was an opportunity to do this.... It should be great!
But let other experts on Access tell their opinion!
:(
PEB 1,418
Expert 1GB
A question?
Are u using Access database or u use your SQL database?
If u use your original SQL database you can pass queris directly to the Server and in this case it should be possible!
But with Access database seems impossible!
:)
 NeoPa 32,556
Expert Mod 16PB
The only parallel processing supported by Access, as far as I know, is Asynchronous execution of queries.
Execute Method
Runs an action query or executes an SQL statement on a specified Connection or Database object.
Syntax
object.Execute source, options
querydef.Execute options
The Execute method syntax has these parts.
Part Description
object A Connection or Database object variable on which the query will run.
querydef An object variable that represents the QueryDef object whose SQL property setting specifies the SQL statement to execute.
source A String that is an SQL statement or the Name property value of a QueryDef object.
options Optional. A constant or combination of constants that determines the data integrity characteristics of the query, as specified in Settings.
Settings
You can use the following constants for options.
Constant Description
dbDenyWrite Denies write permission to other users (Microsoft Jet workspaces only).
dbInconsistent (Default) Executes inconsistent updates (Microsoft Jet workspaces only).
dbConsistent Executes consistent updates (Microsoft Jet workspaces only).
dbSQLPassThrough Executes an SQL pass-through query. Setting this option passes the SQL statement to an ODBC database for processing (Microsoft Jet workspaces only).
dbFailOnError Rolls back updates if an error occurs (Microsoft Jet workspaces only).
dbSeeChanges Generates a run-time error if another user is changing data you are editing (Microsoft Jet workspaces only).
dbRunAsync Executes the query asynchronously (ODBCDirect Connection and QueryDef objects only).
dbExecDirect Executes the statement without first calling SQLPrepare ODBC API function (ODBCDirect Connection and QueryDef objects only).
The only parallel processing supported by Access, as far as I know, is Asynchronous execution of queries.
Thanks for the updates. I have created a passthrough query that is working for me
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Markus Franz |
last post by:
Hi.
I have a difficult problem: An array contains several different URLs.
I want to load these websites in parallel by using a HTTP-Request. How
can I do this in PHP?
Up to now I did this...
|
by: Yuancai \(Charlie\) Ye |
last post by:
Hi, All:
I am happy to annouce that we have formally released our latest SocketPro
version 4 at www.udaparts.com, an advanced remoting framework written from
batching/queue, asynchrony and...
|
by: chellappa |
last post by:
Hi All,
I need information running two function in parallel manner with out
using fork .. because i am trying to use fork ..but fork create two
process ..i will done through any other methods,one...
|
by: ramyach |
last post by:
Hi friends,
I need to write a parallel code in 'C' on the server that is
running SGI Irix 6.5. This server supports MIPS Pro C compiler. I don't
have any idea of parallel C languages. I looked...
|
by: Dave Booker |
last post by:
I'm doing some analysis that is readily broken up into many independent
pieces, on a multicore machine.
I thought it would be best to just queue like 1000 of these pieces in the
ThreadPool, and...
|
by: parallelpython |
last post by:
Has anybody tried to run parallel python applications?
It appears that if your application is computation-bound using 'thread'
or 'threading' modules will not get you any speedup. That is because...
|
by: Rklawton |
last post by:
I'm running Access 2003, and I've got a CPU intensive application that takes hours (or more) to run. Fortunately, I can logically split up the task so it can run in smaller pieces independently.
...
|
by: John |
last post by:
I have a program that needs to run on a regular basis that looks at a
queue table in my database. If there are items in the queue database
I need to grab the data from the database and pass it to...
|
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...
|
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: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
