Record creation slow

[Hal Jenkins]

Hi there..

I have a simple PHP page that adds a record to a fp7database. I am only populating two fields, one number field and one text field. I have found that the text field causes the process of the 'New' request to slow down. If I changed the field type from Text to Number, it takes less that a second as opposed to about 3 seconds as text.

Is there some way to fix this or does it just take longer to process text?

Halski

[mlindal]

off the top of my head...

Try creating a separate layout for your PHP with only the fields you will need. This has worked quite well.

Not sure of the text vs number speed issue for a field.

Just one table? Any relationships based on the fields in question? Is indexing on?