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

How to Optimize Big Table with Many Forms

I've got some software that dynamically generates pages with tables on them.

Each row in the table contains:
* Two data cells, each with one text value
* Two data cells, each with a form and a select

This page worked fine when I started out, but it's proven to be very unwieldy (read: slow) for large data sets.

For example, a page with 1000 entries has 1000 TRs, four thousand TDs, 2000 FORMs, and 2000 SELECTs.

What's likely to be slowing down the page the most? The table itself, the selects, the forms, or some combination thereof? What will give me the best bang-for-the-buck in optimization?

This is an example of the page that's small enough to work well:
http://index.xenagia.net/display-user-collection.phtml?user=ShannonA&site=Xenagia

However, I suspect the answer is general, not page specific.

Thanks.
Aug 10 '09 #1
1 2675
drhowarddrfine
7,435 Expert 4TB
Tables are slow to display but I forgot the reason. Something about calculating the final display size that takes so long.
Aug 10 '09 #2

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

Similar topics

0
by: steve | last post by:
Optimize table in mysql is nice!! but seems to require table names. Any way I can run it for my entire db? I like to do this in a batch process from time to time. FYI, I was having SERIOUS...
0
by: steve | last post by:
I am running mysql 4.0.16. Optimize table does not work with LOCAL or NO_WRITE_TO_BINLOG options, and gives me mysql error. Any ideas? -- http://www.dbForumz.com/ This article was posted by...
6
by: MX1 | last post by:
Hi, I've created a series of navigation buttons to be used as a standard across many forms in an Access DB. Does anyone know an easy way to cut and paste these navigation buttons into each new...
2
by: Chicken Kebab Abdullah | last post by:
Hello, I'm quite new to databases, and I've never really managed to get my head around them completely. Anyway, im designing a small database that keeps track of print consumables that we...
4
by: Just Me | last post by:
Is there some way I can check to see how many forms an application has open? I found MdiChildren.Length but need to know the total number of forms and some are not all MDI children. Thanks
3
by: Sonnich | last post by:
While trying to shorten my files, I tried optimize table - later I found that I need: mysqlcheck -u root -p[password[ --all-databases --analyze --optimize (thanks to Markus Popp). But it...
0
by: ssknov | last post by:
HI , i want to know how to create a class which has an INSERT method for several forms. for example: i have 3 forms , FORM1,FORM2 FORM3. FORM1 has 3 textboxes. FORM2 has 7 textboxes ....
6
by: mcgrathml | last post by:
Hi, A customer has a table with greater than 30 columns (scientific readings). The form used to input the data is very difficult to use and I'd like to ask the group:- (1) Can a main form...
0
by: pedalpete | last post by:
Hey MySql Gurus, I've been having some issues with my database starting a few days ago, though I haven't changed any of the db code in at least 3 weeks. I do some daily maintenance on my...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
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...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...
0
isladogs
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...

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.