On 7/18/2012 11:34 AM, Daniel L. Miller wrote: > On 7/18/2012 8:33 AM, Thomas Eckardt wrote: >> The connection are held until assp stopps. They are checked every 120 >> seconds and renewed if not available. Firefox should have a connection >> timeout of more than 3600 seconds. >> I don't recommend the Firebird DB. The Perl DBD driver is incomplete >> (missing some standard functions) and the DB seems to be too slow. >
I've found something that may or may not be an issue. Reviewing DBI traces, I see regular SQL statements of the form: select * from <table> where pkey='' <table> of course can be any of the tables - but it's the empty where clause that concerns me. I don't know about other databases, but Firebird treats such a statement as an attempt to search for a null - and since we're searching against a defined non-null primary key nothing is returned. Is it a problem to change such SQL statements, where the desire is simply to read the entire table, into: select * from <table> Does that break anything existing? -- Daniel ------------------------------------------------------------------------------ Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ _______________________________________________ Assp-test mailing list Assp-test@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/assp-test
