... any ... I did find the list, but obviously since it was down, I did get much help. However, I did find what the issue was, and I'm going to post my answer...
... The list isn't down. It's the Firebird website that is down....hence the lists page isn't available. Anyway you did subscribe to the firebird-net-provider...
Hi Friends! I'd like to know what is a better choice in general, selectable SP or VIEW? I didn't experienced any performance drawbacks when using SPs instead...
Hi, ... If you do a WHERE clause on your View, you will get a much better plan compared to a SP. With an SP, first the SP itself will be executed and all rows...
Regards Vince Vince Duggan I.T. Manager (Business Systems) Virgin Active South Africa Tel (+27) (0)21 684 3525 Cell (+27) (0)82 907 2086 This e-mail and its...
... In my case it turned out it was running out of disk space (which was a ramdrive for sort tables). But the point is these errors say nothing about what...
A huge sort table gets created (and lousy performance) depending on what I put in the select list, not what I put in the order-by clause. SORT is the root of...
... Generally, it is much faster to retrieve records in storage order than to access them randomly. Unless you happen to store records in the order that...
... Not sure how your answer is related to the problem described. Firebird builds a 1.2GB sort table for ~40 seconds while CPU = 100%. This only happens when I...
... I tried to answer you're question which was, if I understand correctly, why doesn't firebird retrieve only the sort keys on the first pass, then sort them,...
Hi, I have a routine I use in my application which runs a separate query on every table and view in the database. The purpose of these queries is really just...
Hi If you are after field definitions the best way would to just query the RDB$ tables. RDB$Fields probably has a lot of the data you are looking for. Thanks ...
... You could only prepare it, but if you really want to execute a query. you coudl try select first 0 * from YourTable see you ! -- Alexandre Benson Smith ...
Just to explain what you effectively did. The optimizer saw that it had no index that could be used to help getting what you specified in the WHERE clause, and...
... correctly, ... Well, surely it isn't the case in practice, since it makes a file on the same expensive-I/O disk that is 26x than the whole database. The ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
