If I had a dollar for every time a uni came up with a new solar cell. The reality is that most of what you can buy is stil monocrystalline silicone, same as 50 years ago. Why is nothing commercialised?
Slightly off-topic, but I recently had the oppurtunity to test the speed of a MySQL in-memory database. I have some frequently queried read-only data that simply would not handle the load in MS SQL and was looking for an in-memory solution. MySQL provided the simplest implementation - simply tell the table to use memory storage and configure the server to allow the amount of data you want to host (~250MB in this case). You also have to remember to reload the data from normal InnoDB tables every time you restart the server. I used the same table structures, keys indexes and stored procedures (almost the same) to query the data and linked it through MS SQL so that my applications never new the difference. On exactly the same hardware the speed increase was at least 50X over MS SQL.
How the court can even consider comparing stationary technology that operates up to a few hundred meters with something that is 20,000 kilometers away traveling at 14,000 km/h is beyond me. GPS accuracy is effected by builings, mountains, etc.
...compelling data visualizations and tools for customizable visualizations and widgets...we have rich expertise in knowing how users can best view and comprehend data...codify the incoming data-stream into cohesive, relevant data points...and they are building it on Sharepoint.
I guess the USA will get a lot of web 2.0 stats, etc. but will you be able to see who got that contract for fitting the golden faucets in the governor's loo, and how much they were paid?
The Zebra printers have built in barcode fonts, no need to buy another printer or seperate fonts.
A typical line of EPL code looks like [font],[position],[texttoprint], where the font can be any number of barcode fonts built into the printer firmware. Printing a barcode ends up using about 30bytes, much faster than sending the barcode as raster image, and works the same on any OS.
They already fsckd up Freecell in Vista. Luckily you can still copy the older version over from XP. Probably violated their license agreement doing that as well.
Displaying video is the buzz, but the rest of what it does is what possibly makes it worthwhile. It seeks to replace the DHTML/Javascript model something better and more capable. While for now my client side code will still be in raw Javascript, I look forward to the day when I can have proper type safety and OO in my browser.
Because it is clunky.
First off you can't read 117882759 as 2007-05-25 08:45:59 so it makes your result sets less readable.
You have to use inline userdefined functions all the time when you need to convert back to normal dates - good luck if your DB does not support those.
You throw away the built in date/time arithmetic included in the DB. For instance, how would you write this query:
select datepart(year, OrderDT), datepart(month, OrderDT), count(*) as OrderCount from Orders group by datepart(year, OrderDT), datepart(month, OrderDT)
1900 Concurrent connections to Exchange, but I would guess only a few from Exchange to the DB.
Re:The biggest SQL hack of all...
on
SQL Hacks
·
· Score: 1
Some people just don't get it. Here is some typical business logic as defined by business:
If ItemA has Status4 and has been through Process1 three times already send it to Process4.
Except if it has already been through Process4, send it through Process5.
If it has been through Process5 once before set status to Status8.
Except if it the last process it went through has been assigned to Employee23 or Employee46 or any employee in EmplGroup8, in which case you must add an alert to that employees queue.
And that is only for Status4. Wait till you see the rest of the spec.
Now you go implement that in Java/C# or whatever using Hibernate etc and you are gaurenteed to to make an unholy amount of requests to the server and end up with something that is not scaleable. Fact is that most business logic is best implemented in the DBMS, and if you think otherwise you haven't been there yet.
Accpac for DOS had a DOS report writer called Caret, which I believe was the forerunner of Crystal Reports or just had similar features. Back in the day it had pretty amazing capabilities.
I remember Garcia and actually built that ECG circuit back in '87 or so. Didn't have money for the opto-isolators, so i wired it directly to my A/D convertor that was in turn connected directly to my ZX Spectrum. Still used a seperate battery for power, but everything had basically the same ground circuit. I never got any real shocks, just some tingles once or twice, but the fact that it was not completely isolated caused a lot of 50Hz feedback. I had to use a lot of clock cycles in code to clean up the waveform to make it look anything like an ECG.
Those were the days.
We've just taken the plunge after having our 2003 subscription lapse. The MSDN versions has changed somewhat, but i think the professional version is ~$2,500 full price. The top Enterprise one goes for $10k. We settled on the enterprise developer version for ~$5k since it had some stuff we wanted. Upgrade prices are 2/3rd of full I think.
Due to long-running patent litigation by Inpro against R.I.M. in the U.K., U.S.A. and E.U. regarding their patent on the period R.I.M. will hold off on suing the O.P. for infringing their patent on the gratuitous use of periods in acronyms.
Not all webserver-based applications are for general consumption or "the web". Many are just small business tools written in maybe 2 to 10 thousand lines of code. AJAX and all that goes with it is a viable substitute for many of these traditional inhouse applications, without the install/update overhead that goes with a traditional application.
A dhtml/javascript ui using ajax to communicate with the server provides a very acceptable user experience.
And in all likelyhood the whole of SA gets slashdotted as well. Seriously - for a South African it is very irresponsible to put up large image files that every nerd wants to see and then link them from Slahdot.
Totally agree with the parent on keys etc. Keys and their associated indexes or just seperate indexes on columns or groups of colomns provides a major performance boost. Analyse you selects and joins to find the columns that need indexing. And remember that indexes need periodic maintenance - schedule some scripts to rebuild them every few days. Also remember that a query can normally be written in several ways and still provide the same result. Play around till you find the optimal one that makes best use of your indexes.
Regarding the choice of database - I wouldn't consider MySQL a proper RDBMS, but it is VERY good for exactly what you are using it for, so don't look to change. I'm not sure what the state is of replication in MySQL - but for your application where you have to keep track of logins and conversations I suppose only realtime or near realtime merge replication will do if you don't want code changes. So check out what's available and try it out. To really scale properly you will need replication.
Slashdot Mirror
Case well made for NoSQL - it's a great fit for 0.001% of use cases.
If I had a dollar for every time a uni came up with a new solar cell. The reality is that most of what you can buy is stil monocrystalline silicone, same as 50 years ago. Why is nothing commercialised?
Slightly off-topic, but I recently had the oppurtunity to test the speed of a MySQL in-memory database. I have some frequently queried read-only data that simply would not handle the load in MS SQL and was looking for an in-memory solution. MySQL provided the simplest implementation - simply tell the table to use memory storage and configure the server to allow the amount of data you want to host (~250MB in this case). You also have to remember to reload the data from normal InnoDB tables every time you restart the server. I used the same table structures, keys indexes and stored procedures (almost the same) to query the data and linked it through MS SQL so that my applications never new the difference. On exactly the same hardware the speed increase was at least 50X over MS SQL.
How the court can even consider comparing stationary technology that operates up to a few hundred meters with something that is 20,000 kilometers away traveling at 14,000 km/h is beyond me. GPS accuracy is effected by builings, mountains, etc.
...compelling data visualizations and tools for customizable visualizations and widgets...we have rich expertise in knowing how users can best view and comprehend data...codify the incoming data-stream into cohesive, relevant data points...and they are building it on Sharepoint. I guess the USA will get a lot of web 2.0 stats, etc. but will you be able to see who got that contract for fitting the golden faucets in the governor's loo, and how much they were paid?
The Zebra printers have built in barcode fonts, no need to buy another printer or seperate fonts. A typical line of EPL code looks like [font],[position],[texttoprint], where the font can be any number of barcode fonts built into the printer firmware. Printing a barcode ends up using about 30bytes, much faster than sending the barcode as raster image, and works the same on any OS.
And which PHB idea was it to do POS over the internet?
They already fsckd up Freecell in Vista. Luckily you can still copy the older version over from XP. Probably violated their license agreement doing that as well.
Isn't this what Microsoft wanted to do with WinFS? Bold idea, but little difficult to implement?
Why does everything these days have to be prefixed with an i?
Displaying video is the buzz, but the rest of what it does is what possibly makes it worthwhile. It seeks to replace the DHTML/Javascript model something better and more capable. While for now my client side code will still be in raw Javascript, I look forward to the day when I can have proper type safety and OO in my browser.
First off you can't read 117882759 as 2007-05-25 08:45:59 so it makes your result sets less readable.
You have to use inline userdefined functions all the time when you need to convert back to normal dates - good luck if your DB does not support those.
You throw away the built in date/time arithmetic included in the DB. For instance, how would you write this query:
1900 Concurrent connections to Exchange, but I would guess only a few from Exchange to the DB.
Some people just don't get it. Here is some typical business logic as defined by business:
If ItemA has Status4 and has been through Process1 three times already send it to Process4. Except if it has already been through Process4, send it through Process5. If it has been through Process5 once before set status to Status8. Except if it the last process it went through has been assigned to Employee23 or Employee46 or any employee in EmplGroup8, in which case you must add an alert to that employees queue.
And that is only for Status4. Wait till you see the rest of the spec.
Now you go implement that in Java/C# or whatever using Hibernate etc and you are gaurenteed to to make an unholy amount of requests to the server and end up with something that is not scaleable. Fact is that most business logic is best implemented in the DBMS, and if you think otherwise you haven't been there yet.
Accpac for DOS had a DOS report writer called Caret, which I believe was the forerunner of Crystal Reports or just had similar features. Back in the day it had pretty amazing capabilities.
I remember Garcia and actually built that ECG circuit back in '87 or so. Didn't have money for the opto-isolators, so i wired it directly to my A/D convertor that was in turn connected directly to my ZX Spectrum. Still used a seperate battery for power, but everything had basically the same ground circuit. I never got any real shocks, just some tingles once or twice, but the fact that it was not completely isolated caused a lot of 50Hz feedback. I had to use a lot of clock cycles in code to clean up the waveform to make it look anything like an ECG.
Those were the days.
Operating systems are for sissies.
Oh, wait...
We've just taken the plunge after having our 2003 subscription lapse. The MSDN versions has changed somewhat, but i think the professional version is ~$2,500 full price. The top Enterprise one goes for $10k. We settled on the enterprise developer version for ~$5k since it had some stuff we wanted. Upgrade prices are 2/3rd of full I think.
Due to long-running patent litigation by Inpro against R.I.M. in the U.K., U.S.A. and E.U. regarding their patent on the period R.I.M. will hold off on suing the O.P. for infringing their patent on the gratuitous use of periods in acronyms.
Not all webserver-based applications are for general consumption or "the web". Many are just small business tools written in maybe 2 to 10 thousand lines of code. AJAX and all that goes with it is a viable substitute for many of these traditional inhouse applications, without the install/update overhead that goes with a traditional application. A dhtml/javascript ui using ajax to communicate with the server provides a very acceptable user experience.
There are lots of similar players on the market. Why is this one better/more newsworthy? It does not even look cool.
And in all likelyhood the whole of SA gets slashdotted as well. Seriously - for a South African it is very irresponsible to put up large image files that every nerd wants to see and then link them from Slahdot.
Totally agree with the parent on keys etc. Keys and their associated indexes or just seperate indexes on columns or groups of colomns provides a major performance boost. Analyse you selects and joins to find the columns that need indexing. And remember that indexes need periodic maintenance - schedule some scripts to rebuild them every few days. Also remember that a query can normally be written in several ways and still provide the same result. Play around till you find the optimal one that makes best use of your indexes. Regarding the choice of database - I wouldn't consider MySQL a proper RDBMS, but it is VERY good for exactly what you are using it for, so don't look to change. I'm not sure what the state is of replication in MySQL - but for your application where you have to keep track of logins and conversations I suppose only realtime or near realtime merge replication will do if you don't want code changes. So check out what's available and try it out. To really scale properly you will need replication.
www.hellkom.co.za