Another DB Design Question

[cjtaylor]

hello,

I have another database design question. This one has to do with inserting a base64 string into a text field in my db. Again I may have design issues with this, but why in the world would it take 17 seconds to insert 1.7kb worth of text? I can read the record in milliseconds, why would it be different the other way around? What should I do to speed this up or design differently?

Thanks
Chris Taylor

 

[ggggus]

The more indexes you create, the faster data will read out of it, but the slower input will be.

If you have a lot of indexes, you may want to think about deleting the ones you don't really use for quick queries.

If you have imported or deleted a lot of records, you should run an optimze table on the table.

Also defraging hard drives can help.

***************************************
J. Jacobs

http://www.piercedmedia.com