Creating a new row in a table

[alohaaaron]

Hi, I have a fixed header table and when I click "new" it creates a new row within a table. The row is a record within a MySQL table. For some reason it takes about 10 seconds to create this new row. How can I speed it up? There are only about 100 records in the table.

The SQL is:
INSERT INTO Tracking (Time,Date,TrackingNo)VALUES ('$new_time','$today','$tracking')";

Here is a screenshot of the table

http://www.premier-regroup.com/onblur.jpg

Thanks,
Aaron

 

[Vragabond]

We have no way of knowing how you're adding this one row, or how complicated of an operation it is. But since there are no scripting capabilities in HTML or CSS, I would say that you're not asking the question in the right forum. I would suggest either the forum of your server side scripting language or the database. Although the screenshot actually looks like you're using some kind of Access object inside your website.

___________________________________________________________
[small]Do something about world cancer today: Comprehensive cancer control information at PACT[/small]

 

[BillyRayPreachersSon]

Surely this is question for the SQL forum as it has absolutely nothing to do with HTML or CSS?

Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

Dan's Page [blue]@[/blue] Code Couch:

http://www.codecouch.com/dan/

Code Couch Tech Snippets & Info:

http://www.codecouch.com/

 

[alohaaaron]

I am not sure if CSS is slowing it down? With about 100 rows could CSS be the reason it loads slowly? It also has javascript that resizes the rows dynamically on loading.

 

[Vragabond]

We have no idea what your CSS looks like, where would CSS come into play (is it inline, because external CSS sheet should be cached by the time you're adding rows), or even what your HTML looks like, based on information you've given us (a SQL statement and a photo). If you really think presentation is at fault here, show us how you achieve the presentation and we'll tell you. But I am sure that CSS can hardly be a problem.

___________________________________________________________
[small]Do something about world cancer today: Comprehensive cancer control information at PACT[/small]

 

[BillyRayPreachersSon]

There is still ambiguity around whether your slowdown is client-side or server-side. Can you clarify?

Right now, I'm going on your statement:

The row is a record within a MySQL table. For some reason it takes about 10 seconds to create this new row.

This says to me that the slowdown is creating the MySQL row, and absolutely nothing at all to do with client-side - which is why I advised going to an SQL forum.

Dan



Coedit Limited - Delivering standards compliant, accessible web solutions

Dan's Page [blue]@[/blue] Code Couch:

http://www.codecouch.com/dan/

Code Couch Tech Snippets & Info:

http://www.codecouch.com/