Click here to register.
      
Sprechen Sie WebGUI? Parlez vous WebGUI? Se habla WebGUI? Spreekt u WebGUI?

Do you speak WebGUI? Please help us translate WebGUI into your language.



     Discuss > Etcetera

SQLForm view file very slow?

User robbert
Date 12/13/2007 4:23 am
Views 1055
Rating 15    Rate [
|
]
Previous · Next
User Message
robbert

Hi,

I'am using a SQLForm with file upload. When I upload a file and click on the link to display the file it seems to take forever. I tested it with a few images and a file. A picture of 24kB is no problem (a view seconds), but with an image of 41kB it takes two minutes.

Does anyone experience the same problem, or got any idea what could cause this?

--- (Edited on 12/13/2007 4:23 am [GMT-0600] by robbert) ---



Back to Top
Rate [
|
]
 
 
robbert
Anyone?

--- (Edited on 12/18/2007 5:18 am [GMT-0600] by robbert) ---



Back to Top
Rate [
|
]
 
 
bartjol

Hard to say, if I understand correcly, the SQL query gives the name of a file in the uploads folder (see http://www.webgui.org/bugs/tracker/sqlform-file-upload/1 ) , this should take a same amount of time for small or big files as only the name is processed by the DB.

If I'm correct the problem should be somewhere else than the DB, unfortunately I'm not sure where

--- (Edited on 12/18/2007 5:30 pm [GMT+0100] by bartjol) ---



Back to Top
Rate [
|
]
 
 
robbert

Hard to say, if I understand correcly, the SQL query gives the name of a file in the uploads folder (see http://www.webgui.org/bugs/tracker/sqlform-file-upload/1 ) , this should take a same amount of time for small or big files as only the name is processed by the DB.

If I'm correct the problem should be somewhere else than the DB, unfortunately I'm not sure where

--- (Edited on 12/18/2007 5:30 pm [GMT+0100] by bartjol) ---

No, the image is stored in the database as a blob, not in the upload folder. 

--- (Edited on 12/19/2007 1:07 am [GMT-0600] by robbert) ---



Back to Top
Rate [
|
]
 
 
     Discuss > Etcetera



Recent Discussions Color Key

Design:

Development:

Et Cetera:

Install/Upgrade:  

Smoketest:

Template Group:


Re: Übersetzungen vor dem nächsten Treffen - Translations to be done before the next meeting will take place. by koen - Mon @ 05:17pm

Übersetzungen vor dem nächsten Treffen by bernd - Mon @ 03:09pm

Re: Auth memcookie by JohnRestrepo - Mon @ 12:57pm

Re: Auth memcookie by JT - Mon @ 11:31am

Auth memcookie by JohnRestrepo - Mon @ 10:40am

Re: Patch for wremonitor by JT - Mon @ 10:36am

Patch for wremonitor by knowmad - Mon @ 10:26am

Re: Synopsis search results by knowmad - Mon @ 10:19am

Synopsis search results by marieken - Mon @ 05:49am

Re: Question concerning approval workflows by preaction - Mon @ 02:05am

Re: Question concerning approval workflows by perlDreamer - Sun @ 08:03pm

Re: Help With Octal Math by perlDreamer - Sun @ 07:43pm