i am developing a system using VB 6 and Ms Access 2000.
overall the system is working fine but at few instances
the program get stuck for few minutes like 2 to 3 minutes
i.e it is very slow.
the accasions where it gets slow exists when number of
records exceeeds 10,000 records.
Main Ocasion where program gets slow
in a table there is a field number,lenofnum ,sale1,sale2
if we insert 10 records in a table from number 0-to-9
and in sale1 and sale2 we insert value 10,000 and
lenofnum=1.
now we want some sort of convertion.
like for each of the ten numbers i want to convvert that
single number number into each possible combination of
its double number. like
number 0 would be conveterd into
00,01,02,03,04, 05,06,07,08,09 and the lenofnumwillbec ome
2 and sale1 and sale2 would be divided into 10 equal
segments.
similarly number 1,2.....9 will be break in the same
sequence. this was single to double convertion.
now double to tripple.
like 00 will be converted into 000,001,002...0 09 again in
ten sub divions
then tripplet to four.
major problem occurs from tripplet to four bcoz then
number of tripplets are 1000 and when the split into four
they become 10000 and it takes 1 min 30 secs.
i ve tried my level best to decrease the time below a
minute but not succeded.
i ve also tried sybalse sql anywhere 5.0 but that took
more than 1 1/2 mins.
so pleeeease suggest me someything
please email me the solution 1 1295
upgrading to VB.NET and SQL server would go a lot faster ;p
seriously a access db isn't strong enough to handle that kind of load (it
wil work but not performant) if you think the number of records will keep
increasing in this way upgrade before your system hangs competely.
my 2 cents
eric
"Noman" <ri**********@h otmail.com> wrote in message
news:04******** *************** *****@phx.gbl.. . i am developing a system using VB 6 and Ms Access 2000. overall the system is working fine but at few instances the program get stuck for few minutes like 2 to 3 minutes i.e it is very slow. the accasions where it gets slow exists when number of records exceeeds 10,000 records.
Main Ocasion where program gets slow
in a table there is a field number,lenofnum ,sale1,sale2 if we insert 10 records in a table from number 0-to-9 and in sale1 and sale2 we insert value 10,000 and lenofnum=1. now we want some sort of convertion. like for each of the ten numbers i want to convvert that single number number into each possible combination of its double number. like number 0 would be conveterd into 00,01,02,03,04, 05,06,07,08,09 and the lenofnumwillbec ome 2 and sale1 and sale2 would be divided into 10 equal segments. similarly number 1,2.....9 will be break in the same sequence. this was single to double convertion. now double to tripple. like 00 will be converted into 000,001,002...0 09 again in ten sub divions then tripplet to four. major problem occurs from tripplet to four bcoz then number of tripplets are 1000 and when the split into four they become 10000 and it takes 1 min 30 secs. i ve tried my level best to decrease the time below a minute but not succeded. i ve also tried sybalse sql anywhere 5.0 but that took more than 1 1/2 mins. so pleeeease suggest me someything please email me the solution This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Jason |
last post by:
Hey,
I'm an experience programmer but new to Python. I'm doing a simple
implementation of a field morphing techinique due to Beier and Neely
(1992) and I have the simple case working in Python 2.3 - but it's
REALLY slow.
Basically, you specify two directed line segments in the coordinate
system of a raster image and use the difference between those two
lines to transform the image.
|
by: DJJ |
last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time to load making any kind linkage
with my Access data virtually useless.
I have the MySQL driver setup in as a USER DSN. The MySQL data is sitting
out on a server and the Access database is running locally. The network
connection is very...
|
by: Neil |
last post by:
I've been discussing here a SQL 7 view which scrolls slowly when linked to
an Access 2000 MDB. After trying various things, I've distilled it down to
the following: when the linked view has a virtual primary key, it is slow;
when there is no virtual primary key, it scrolls quickly.
Looking at Profiler, I see that when there is no virtual primary key, Access
sends a simple select command to SQL Server. However, when there is a
virtual...
|
by: Geoff Jones |
last post by:
Hi All
I hope you'll forgive me for posting this here (I've also posted to ado site
but with no response so far) as I'm urgently after a solution.
Can anybody help me? I'm updating a table on a database i.e. I've modified
the table in a DataSet and I want to update it to the SQL database which the
table originally came from. I'm using a data adaptor and the update command
and it works BUT it is soooooooooo slow!!! Can anybody tell me...
|
by: Fredrik Melin |
last post by:
Running a solution with about 20 sub-projects total about 150.000 lines of
code.
Typing code is slow (delay when typing fast).
Pressing next line while debugging is slow.
Pressing Ctrl-F for quick find is rediculous slow.
Everything is slow.
Running Exe is fine though
This is on a HP Workstation machine with Xeon 3GHz (HT Enabled) with 2 GB
| |
by: diffuser78 |
last post by:
I have just started to learn python. Some said that its slow. Can
somebody pin point the issue.
Thans
|
by: lawrence k |
last post by:
The following function is way too slow. If anyone has any suggestions
about how to speed it up, I'd be grateful for them. We have to call
this function 36 times on one page, and I think each time it takes half
a second, so it adds up to maybe 18 seconds, which is a lot when you're
showing software to a client. The reponse we get is "Why is it so
slow?"
<?php
|
by: grace |
last post by:
i am wondering why my database retrieval becomes too slow...we set up
a new server (ubuntu, breezy badger) machine where we transferred all
our files from the old server.. Our new server uses Asus p5pe-vm
motherboard and an Intel Pentium D 3.0Ghz processor, compared to the
old one where we uses asrock motherboard and AMD Duron. Both has the
same version of mysql installed...
To summarized, both machine has the same configuration except...
|
by: bfoo75 |
last post by:
Hi there, I'm new to this forum, but I've come here quite a bit to find solutions to problems other people have encountered... I'm currently trying to query a database up to 5000 times as fast as possible to retrieve certain pricing data for a list of companies. I've run into a few queries that seem to be taking much longer then others and ultimately slow down my function call to a point where it is no longer useful. For instance... I have...
|
by: cm_gui |
last post by:
Python is slow. Almost all of the web applications written in
Python are slow. Zope/Plone is slow, sloow, so very slooow. Even
Google Apps is not faster. Neither is Youtube.
Facebook and Wikipedia (Mediawiki), written in PHP, are so much faster
than Python.
Okay, they probably use caching or some code compilation -- but Google
Apps and those Zope sites probably also use caching.
I've yet to see a web application written in...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |