Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-09-28 08:08 AM

Excel VS SQL Database

Hi,

Can anyone help me out?

I currently have a nice and stable QVW in which it has a lot of records in it..currently this records are being read by qlikview from excel spreadsheets and like my reload time in the server takes about 1.5 hours to finish. Now thats a very long time to wait for my records be updated in the server. My question is would my reload time be ay faster if i were to convert all my excel spreadsheets into a one big database?

Can you guys give me like a Pro's and Con's of having a database and having non?

hope to get some feedbacks from the comunity.

Thanks in advance!

3,231 Views
0 Likes
10 Replies
Not applicable
‎2010-10-01 04:33 AM
Author

In response to

Rob, Gordon,

Thanks so much for your helpful insights regarding this matter.

Yes I am getting optimized loads on my QVDs..I am now happy with where i'm at with my reload time, for the facts that you have all given me than you so much it was a very great help.

Regards to all of you thanks again for all the help.

Big Smile

166 Views
0 Likes