473,322 Members | 1,241 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.

[ODBC] form linked to odbc tables with "high" number of record

Talking about high number of record seem ridiculus, if this number is
about 88.000

but
when I open a form, linked via ODBC to a MYSQL table, the open and the
use of that form is slow, and very slow if the form has combo
controls.

I have a order form, and a combo control for custemer codes.
Order table counts 88.000 records, customer tables has 1.500 records.

Is there a "correct" way, for performance, to manage this "normal"
situation?

Gianluca (not so happy... :-)
Nov 13 '05 #1
2 1382
Gianluca_Venezia wrote:
Talking about high number of record seem ridiculus, if this number is
about 88.000

but
when I open a form, linked via ODBC to a MYSQL table, the open and the
use of that form is slow, and very slow if the form has combo
controls.

I have a order form, and a combo control for custemer codes.
Order table counts 88.000 records, customer tables has 1.500 records.

Is there a "correct" way, for performance, to manage this "normal"
situation?

Gianluca (not so happy... :-)


http://www.trevor.easynet.co.uk/AccFAQ/perf.htm

Also try basing your form on a query that returns only one record, roll
your own search for the form as well.

--
This sig left intentionally blank
Nov 13 '05 #2
Thanks for your link, that has confirmed what I have find about combo
boxes.
After all, and after my direct test, I finally accept to forgot combo
box on large db.
I think to use a search form based on query, and when an user insert
for a customer id code the event/situations will be:
- case 1. (ex not in list) - no id find, open an insert form
- case 2. (ex in list) - if id find, collect data from user table

Bye
Gianluca

Nov 13 '05 #3

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

Similar topics

41
by: AngleWyrm | last post by:
I have created a new container class, called the hat. It provides random selection of user objects, both with and without replacement, with non-uniform probabilities. Uniform probabilities are a...
3
by: maricel | last post by:
Is there a way to list (using db2 command or catalogs) to list hierarchy of table parent & child relationship: 1) A list that shows which table should be deleted first,second,third... 2) A list...
3
by: sql-db2-dba | last post by:
When I did db2batch to benchmark a query, it performance details came back with this reading ... "High water mark for database heap = 4291373408" Does this mean it would have caused memory...
5
by: Serge Rielau | last post by:
Contains a major blurp on SELECT FROM INSERT and some other hopefully useful tricks. http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0411rielau/ Enjoy Serge
1
by: Jean-Marc Blaise | last post by:
Hi Serge, I have a question on your exciting recent article on High Perf. SQL: why do we have to describe datatype for include columns in an INSERT .... INCLUDE .... statement - in your example,...
8
by: Tamir Khason | last post by:
I just testing my program on Windows PE with Framework 1.1 pre-installed and got a message "high encryption pack not installed" - what's the hell? The only information I found in inet is related to...
9
by: Mike Labosh | last post by:
Code is easy. These are two OOP design issues that I am chewing on. Coming from classic VB, I'm not great at OO design. I prefer to write mile long spaghetti methods in a Temp module, and then...
3
blazedaces
by: blazedaces | last post by:
I was working all day yesterday (and will probably be for most of today) with bytecode where java wrote the bytecode and matlab read it... I had never worked with bytecode in great detail before so...
1
by: ALi Shaikh | last post by:
I searched the net countless times yet i am not able to find anything at all....does any know where I can find some info..??
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...
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...
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: 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...
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.